DROP DATABASE IF EXISTS swan_cloud_system;
CREATE DATABASE IF NOT EXISTS swan_cloud_system DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

USE swan_cloud_system;


SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for swan_ent_dept
-- ----------------------------
DROP TABLE IF EXISTS `swan_ent_dept`;
CREATE TABLE `swan_ent_dept`  (
  `dept_id` bigint(20) NOT NULL COMMENT '部门id',
  `dept_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称',
  `dept_short_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门简称',
  `dept_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门编码',
  `parent_id` bigint(20) NULL DEFAULT -1 COMMENT '上级部门',
  `parent_ids` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '-1' COMMENT '所有上级部门ID',
  `status` int(11) NULL DEFAULT NULL COMMENT '状态（1:启用，2：禁用）',
  `order_no` decimal(11, 2) NULL DEFAULT NULL COMMENT '排序',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门描述',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`dept_id`) USING BTREE,
  UNIQUE INDEX `deptId_index`(`dept_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门表';

-- ----------------------------
-- Records of swan_ent_dept
-- ----------------------------
BEGIN;
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192428625308180481, '总务部', '总务部', 'DEPT20191107ZWB', -1, '-1', 1, 1.00, NULL, '2019-11-07 13:08:33', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192428748239036417, '会计部', '会计部', 'DEPT20191107HJB', -1, '-1', 1, 2.00, '', '2019-11-07 13:09:02', 1184285445204418561, '2020-10-27 17:16:55', 1184285445204418561);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192428819550593025, '财务部', '财务部', 'DEPT20191107CWB', -1, '-1', 1, 3.00, '', '2019-11-07 13:09:19', 1184285445204418561, '2020-10-27 17:16:19', 1184285445204418561);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192429230290395137, '业务开发部', '业务开发部', 'DEPT20191107YWKFB', -1, '-1', 1, 4.00, NULL, '2019-11-07 13:10:57', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192429335382876162, '人事部', '人事部', 'DEPT20191107RSB', -1, '-1', 1, 5.00, NULL, '2019-11-07 13:11:22', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192429396128980994, '劳务部', '劳务部', 'DEPT20191107LWB', -1, '-1', 1, 6.00, NULL, '2019-11-07 13:11:37', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192429526785744897, '企划部', '企划部', 'DEPT20191107QHB', -1, '-1', 1, 7.00, NULL, '2019-11-07 13:12:08', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192429636303216641, '管理部', '管理部', 'DEPT20191107GLB', -1, '-1', 1, 8.00, NULL, '2019-11-07 13:12:34', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192429690703339521, '法律部', '法律部', 'DEPT20191107FLB', -1, '-1', 1, 9.00, NULL, '2019-11-07 13:12:47', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192430025102614530, '人力开发部', '人力开发部', 'DEPT20191107RLKFB', -1, '-1', 1, 10.00, NULL, '2019-11-07 13:14:07', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192430088797315073, '教育培训部', '教育培训部', 'DEPT20191107JYPXB', -1, '-1', 1, 11.00, NULL, '2019-11-07 13:14:22', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192430173727776769, '信用部', '信用部', 'DEPT20191107XYB', -1, '-1', 1, 12.00, NULL, '2019-11-07 13:14:42', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192430290115518466, '国际部', '国际部', 'DEPT20191107GJB', -1, '-1', 1, 13.00, NULL, '2019-11-07 13:15:10', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192430354275786755, '采购部', '采购部', 'DEPT20191107CGB', -1, '-1', 1, 14.00, NULL, '2019-11-07 13:15:25', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192430430830223361, '设计部', '设计部', 'DEPT20191107SJB', -1, '-1', 1, 15.00, NULL, '2019-11-07 13:15:44', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1321020371399069697, '测试部门', '测试部门', 'DEPT20201027CSBM', 1192428625308180481, '-1,1192428625308180481', 1, 16.00, '测试部门', '2020-10-27 17:26:15', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1321024141658935297, '222', '222', 'DEPT20201027222', 1321020371399069697, '-1,1192428625308180481,1321020371399069697', 1, 17.00, '222333', '2020-10-27 17:41:13', 1184285445204418561, '2020-10-27 17:54:14', 1184285445204418561);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1321027283465261058, '333', '333', 'DEPT20201027333', 1321020371399069697, '-1,1192428625308180481,1321020371399069697', 1, 18.00, '333', '2020-10-27 17:53:43', 1184285445204418561, '2020-10-27 18:23:21', 1184285445204418561);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1322043068025364481, '测试小组21', '测21', 'DEPT20201030CSXZ21', 1321024141658935297, '-1,1192428625308180481,1321020371399069697,1321024141658935297', 1, 19.00, '测试最小小组', '2020-10-30 13:10:04', 1321991053345775618, NULL, NULL);
INSERT INTO `swan_ent_dept` (`dept_id`, `dept_name`, `dept_short_name`, `dept_code`, `parent_id`, `parent_ids`, `status`, `order_no`, `description`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1322062146983124993, '444', '444', 'DEPT20201030444', 1321020371399069697, '-1,1192428625308180481,1321020371399069697', 1, 20.00, NULL, '2020-10-30 14:25:53', 1184285445204418561, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for swan_ent_duty
-- ----------------------------
DROP TABLE IF EXISTS `swan_ent_duty`;
CREATE TABLE `swan_ent_duty`  (
  `duty_id` bigint(20) NOT NULL COMMENT '职务管理ID',
  `duty_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职务唯一业务编码',
  `duty_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职务名称',
  `order_no` decimal(11, 2) NULL DEFAULT NULL COMMENT '排序码',
  `status` int(11) NULL DEFAULT NULL COMMENT '状态(1:启用,2:禁用)',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`duty_id`) USING BTREE,
  UNIQUE INDEX `duty_manageId_index`(`duty_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '职务管理';

-- ----------------------------
-- Records of swan_ent_duty
-- ----------------------------
BEGIN;
INSERT INTO `swan_ent_duty` (`duty_id`, `duty_code`, `duty_name`, `order_no`, `status`, `description`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1192432207281545219, 'DUTY20191107DSJZX', '董事局主席', 1.00, 1, NULL, 1184285445204418561, '2019-11-07 13:22:47', NULL, NULL);
INSERT INTO `swan_ent_duty` (`duty_id`, `duty_code`, `duty_name`, `order_no`, `status`, `description`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1192432287837347843, 'DUTY20191107DSZ', '董事长', 2.00, 1, '公司最大股东，掌握公司核心资源', 1184285445204418561, '2019-11-07 13:23:06', 1184285445204418561, '2020-10-29 10:54:57');
INSERT INTO `swan_ent_duty` (`duty_id`, `duty_code`, `duty_name`, `order_no`, `status`, `description`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1192432340404559875, 'DUTY20191107ZJL', '总经理', 3.00, 1, NULL, 1184285445204418561, '2019-11-07 13:23:19', NULL, NULL);
INSERT INTO `swan_ent_duty` (`duty_id`, `duty_code`, `duty_name`, `order_no`, `status`, `description`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1192432395551268867, 'DUTY20191107JL', '副总经理', 4.00, 1, '', 1184285445204418561, '2019-11-07 13:23:32', 1184285445204418561, '2019-11-07 13:25:16');
INSERT INTO `swan_ent_duty` (`duty_id`, `duty_code`, `duty_name`, `order_no`, `status`, `description`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1192432495065325570, 'DUTY20191107ZG', '部门经理', 5.00, 1, '', 1184285445204418561, '2019-11-07 13:23:56', 1184285445204418561, '2019-11-07 13:25:35');
INSERT INTO `swan_ent_duty` (`duty_id`, `duty_code`, `duty_name`, `order_no`, `status`, `description`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1192432594071871490, 'DUTY20191107BZ', '部门副经理', 7.00, 1, '', 1184285445204418561, '2019-11-07 13:24:19', 1184285445204418561, '2019-11-07 13:25:46');
INSERT INTO `swan_ent_duty` (`duty_id`, `duty_code`, `duty_name`, `order_no`, `status`, `description`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1192433024638148610, 'DUTY20191107BMZG', '部门主管', 8.00, 1, '', 1184285445204418561, '2019-11-07 13:26:02', 1184285445204418561, '2019-11-07 13:26:09');
INSERT INTO `swan_ent_duty` (`duty_id`, `duty_code`, `duty_name`, `order_no`, `status`, `description`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1192433128765939714, 'DUTY20191107BMFGLD', '部门分管领导', 9.00, 1, NULL, 1184285445204418561, '2019-11-07 13:26:27', NULL, NULL);
INSERT INTO `swan_ent_duty` (`duty_id`, `duty_code`, `duty_name`, `order_no`, `status`, `description`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1192433193878315011, 'DUTY20191107ZZ', '组长', 10.00, 1, NULL, 1184285445204418561, '2019-11-07 13:26:42', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for swan_ent_user
-- ----------------------------
DROP TABLE IF EXISTS `swan_ent_user`;
CREATE TABLE `swan_ent_user`  (
  `user_id` bigint(20) NOT NULL COMMENT '用户信息id',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `user_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户编码',
  `last_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓',
  `first_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名',
  `last_name_pinyin` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓（拼音）',
  `first_name_pinyin` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名（拼音）',
  `sex` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别(M:男   F:女)',
  `birthday` datetime(0) NULL DEFAULT NULL COMMENT '生日',
  `education` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学历（字典项）',
  `birthplace` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '籍贯',
  `nation` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族',
  `id_card` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号',
  `matrimony` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '婚姻状况（字典项）',
  `political` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '政治面貌（字典项）',
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
  `mobile_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `avatar_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户头像地址',
  `order_no` decimal(11, 2) NULL DEFAULT 9999.00 COMMENT '排序码',
  `status` int(11) NULL DEFAULT 1 COMMENT '状态(1:启用  2:禁用)',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE INDEX `infoId_index`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户信息';

-- ----------------------------
-- Records of swan_ent_user
-- ----------------------------
BEGIN;
INSERT INTO `swan_ent_user` (`user_id`, `name`, `user_code`, `last_name`, `first_name`, `last_name_pinyin`, `first_name_pinyin`, `sex`, `birthday`, `education`, `birthplace`, `nation`, `id_card`, `matrimony`, `political`, `email`, `phone`, `mobile_phone`, `avatar_url`, `order_no`, `status`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1, '超级管理员', 'SYSTEM_USER_1', '超级', '管理员', NULL, NULL, 'M', '2011-10-03 16:00:00', NULL, NULL, NULL, NULL, NULL, NULL, '1225486625@qq.com', '12138987654', NULL, 'http://192.168.9.247:8000/swan-cloud-system/file/preview?fileId=1321985150420738050', 9999.00, 1, '2019-10-16 01:50:28', -100, '2020-10-30 09:20:17', 1184285445204418561);
INSERT INTO `swan_ent_user` (`user_id`, `name`, `user_code`, `last_name`, `first_name`, `last_name_pinyin`, `first_name_pinyin`, `sex`, `birthday`, `education`, `birthplace`, `nation`, `id_card`, `matrimony`, `political`, `email`, `phone`, `mobile_phone`, `avatar_url`, `order_no`, `status`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192435298991104001, '何享健', 'USER20191107HXJM20191103', '何', '享健', 'he', 'xiangjian', 'M', '2019-11-03 00:00:00', 'MASTER', '中国', '汉族', '112256789654356784', 'MARRIED', 'PARTY', 'dfe5432@163.com', '18636372765', '18636372765', NULL, 10002.00, 2, '2019-11-07 13:35:04', 1184285445204418561, '2020-10-30 13:28:52', 1321991053345775618);
INSERT INTO `swan_ent_user` (`user_id`, `name`, `user_code`, `last_name`, `first_name`, `last_name_pinyin`, `first_name_pinyin`, `sex`, `birthday`, `education`, `birthplace`, `nation`, `id_card`, `matrimony`, `political`, `email`, `phone`, `mobile_phone`, `avatar_url`, `order_no`, `status`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192435630169153538, '黄惠祥', 'USER20191107HHXM20101107', '黄', '惠祥', 'huang', 'huixiang', 'M', '2010-11-07 00:00:00', 'MASTER', '中国', '汉族', '3342343233231321453', 'MARRIED', 'MASSES', '45465521@163.com', '18636370098', '18636370098', NULL, 10003.00, 2, '2019-11-07 13:36:23', 1184285445204418561, '2020-10-30 13:33:08', 1184285445204418561);
INSERT INTO `swan_ent_user` (`user_id`, `name`, `user_code`, `last_name`, `first_name`, `last_name_pinyin`, `first_name_pinyin`, `sex`, `birthday`, `education`, `birthplace`, `nation`, `id_card`, `matrimony`, `political`, `email`, `phone`, `mobile_phone`, `avatar_url`, `order_no`, `status`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1192435904405331969, '李文达', 'USER20191107LWDM20151101', '李', '文达', 'li', 'wenda', 'M', '2015-11-01 00:00:00', 'MASTER', '中国', '汉族', '213213344676654545', 'MARRIED', 'MASSES', '45546345@163.com', '18636372709', '18636372709', NULL, 10004.00, 1, '2019-11-07 13:37:29', 1184285445204418561, NULL, NULL);
INSERT INTO `swan_ent_user` (`user_id`, `name`, `user_code`, `last_name`, `first_name`, `last_name_pinyin`, `first_name_pinyin`, `sex`, `birthday`, `education`, `birthplace`, `nation`, `id_card`, `matrimony`, `political`, `email`, `phone`, `mobile_phone`, `avatar_url`, `order_no`, `status`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1321991052968288258, '陈翔', 'USER20201030CXM20201030', '陈', '翔', 'Chen', 'Xiang', 'M', '2020-10-30 00:00:00', '1183727829133664258', '山西', '汉', '140103197602285013', '1183728219208093697', '1183729632801746946', 'chenxiang@xnewtech.com', '18611344806', '13601200601', 'http://192.168.9.247:8000/swan-cloud-system/file/preview?fileId=1321991534843486210', 10005.00, 1, '2020-10-30 09:43:23', 1184285445204418561, '2020-10-30 13:35:25', 1321991053345775618);
INSERT INTO `swan_ent_user` (`user_id`, `name`, `user_code`, `last_name`, `first_name`, `last_name_pinyin`, `first_name_pinyin`, `sex`, `birthday`, `education`, `birthplace`, `nation`, `id_card`, `matrimony`, `political`, `email`, `phone`, `mobile_phone`, `avatar_url`, `order_no`, `status`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (1321998412843540481, '吴雄', 'USER20201030WXM19911016', '吴', '雄', 'wu', 'wyatt', 'M', '1991-10-16 00:00:00', '1321369478214938626', '甘肃陇西', '汉族', '622425199110164872', '1183728535072669697', '1183729049877463041', '236563508@qq.com', '17343169572', '17343169572', 'http://192.168.9.247:8000/swan-cloud-system/file/preview?fileId=1321998936368177154', 10006.00, 1, '2020-10-30 10:12:38', 1184285445204418561, '2020-10-30 10:46:08', 1184285445204418561);
COMMIT;

-- ----------------------------
-- Table structure for swan_ent_user_account
-- ----------------------------
DROP TABLE IF EXISTS `swan_ent_user_account`;
CREATE TABLE `swan_ent_user_account`  (
  `account_id` bigint(20) NOT NULL COMMENT '账号id',
  `account` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号(工卡号)',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `salt` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码盐',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户信息id',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
  `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`account_id`) USING BTREE,
  UNIQUE INDEX `accountId_index`(`account_id`) USING BTREE,
  INDEX `infoId_index`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '登录账号';

-- ----------------------------
-- Records of swan_ent_user_account
-- ----------------------------
BEGIN;
INSERT INTO `swan_ent_user_account` (`account_id`, `account`, `password`, `salt`, `user_id`, `create_time`, `create_user`, `update_time`, `update_user`, `del_flag`) VALUES (1184285445204418561, 'admin', '5095826806ac6f741a5df27bab842e28', '0v6hv', 1, '2019-10-16 01:50:27', -100, '2019-11-07 13:27:39', 1184285445204418561, NULL);
INSERT INTO `swan_ent_user_account` (`account_id`, `account`, `password`, `salt`, `user_id`, `create_time`, `create_user`, `update_time`, `update_user`, `del_flag`) VALUES (1192435299083378690, 'hxj', 'a1f46c77389b1c83084e695edadc1467', 'gmyxh', 1192435298991104001, '2019-11-07 13:35:04', 1184285445204418561, '2020-10-30 10:00:25', 1184285445204418561, 'N');
INSERT INTO `swan_ent_user_account` (`account_id`, `account`, `password`, `salt`, `user_id`, `create_time`, `create_user`, `update_time`, `update_user`, `del_flag`) VALUES (1192435630265622530, 'hhx', '5095826806ac6f741a5df27bab842e28', '0v6hv', 1192435630169153538, '2019-11-07 13:36:23', 1184285445204418561, NULL, NULL, 'N');
INSERT INTO `swan_ent_user_account` (`account_id`, `account`, `password`, `salt`, `user_id`, `create_time`, `create_user`, `update_time`, `update_user`, `del_flag`) VALUES (1192435904476635137, 'lwd', '244cdd8795e189cd875e047762bf2c58', 'eb7bc', 1192435904405331969, '2019-11-07 13:37:29', 1184285445204418561, '2020-11-02 15:58:02', 1184285445204418561, 'N');
INSERT INTO `swan_ent_user_account` (`account_id`, `account`, `password`, `salt`, `user_id`, `create_time`, `create_user`, `update_time`, `update_user`, `del_flag`) VALUES (1321991053345775618, 'cx', '25cddd6c82f8f4bc2fe21e022433a566', 'o7nr7', 1321991052968288258, '2020-10-30 09:43:23', 1184285445204418561, NULL, NULL, 'N');
INSERT INTO `swan_ent_user_account` (`account_id`, `account`, `password`, `salt`, `user_id`, `create_time`, `create_user`, `update_time`, `update_user`, `del_flag`) VALUES (1321998412927426561, 'wyatt', '24bb9e1e2c6634d55e3f443a0737cbf5', 'id010', 1321998412843540481, '2020-10-30 10:12:38', 1184285445204418561, '2020-10-30 10:49:38', 1321998412927426561, 'N');
COMMIT;

-- ----------------------------
-- Table structure for swan_ent_user_dept
-- ----------------------------
DROP TABLE IF EXISTS `swan_ent_user_dept`;
CREATE TABLE `swan_ent_user_dept`  (
  `user_dept_id` bigint(20) NOT NULL COMMENT '主键',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `duty_id` bigint(20) NOT NULL COMMENT '职务id',
  `dept_id` bigint(20) NOT NULL COMMENT '部门id',
  `default_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N' COMMENT '是否为 默认部门(\'N\'代表否,\'Y\'代表是)',
  PRIMARY KEY (`user_dept_id`) USING BTREE,
  INDEX `duty_index`(`duty_id`) USING BTREE,
  INDEX `infoId_index`(`user_id`) USING BTREE,
  INDEX `deptId_index`(`dept_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户部门关联表';

-- ----------------------------
-- Records of swan_ent_user_dept
-- ----------------------------
BEGIN;
INSERT INTO `swan_ent_user_dept` (`user_dept_id`, `user_id`, `duty_id`, `dept_id`, `default_flag`) VALUES (1192435299058212865, 1192435298991104001, 1192432207281545219, 1192429636303216641, 'Y');
INSERT INTO `swan_ent_user_dept` (`user_dept_id`, `user_id`, `duty_id`, `dept_id`, `default_flag`) VALUES (1192435904472440833, 1192435904405331969, 1192432207281545219, 1192430354275786755, 'Y');
INSERT INTO `swan_ent_user_dept` (`user_dept_id`, `user_id`, `duty_id`, `dept_id`, `default_flag`) VALUES (1321369945502347265, 1192435630169153538, 1192432207281545219, 1192430088797315073, 'Y');
INSERT INTO `swan_ent_user_dept` (`user_dept_id`, `user_id`, `duty_id`, `dept_id`, `default_flag`) VALUES (1321369945510735874, 1192435630169153538, 1192432395551268867, 1192430173727776769, 'N');
INSERT INTO `swan_ent_user_dept` (`user_dept_id`, `user_id`, `duty_id`, `dept_id`, `default_flag`) VALUES (1322006845529481217, 1321998412843540481, 1192432340404559875, 1192429636303216641, 'Y');
INSERT INTO `swan_ent_user_dept` (`user_dept_id`, `user_id`, `duty_id`, `dept_id`, `default_flag`) VALUES (1322049444130807809, 1321991052968288258, 1192432340404559875, 1192428748239036417, 'Y');
COMMIT;

-- ----------------------------
-- Table structure for swan_fileinfo
-- ----------------------------
DROP TABLE IF EXISTS `swan_fileinfo`;
CREATE TABLE `swan_fileinfo`  (
  `file_id` bigint(20) NOT NULL COMMENT 'infoId',
  `file_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `file_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件路径',
  `file_size` decimal(11, 2) NULL DEFAULT NULL COMMENT '文件大小',
  `file_final_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件存储路径',
  `file_suffix` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件后缀',
  `app_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用编码',
  `app_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用名称',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '删除标记（N:未删除，Y:删除）',
  PRIMARY KEY (`file_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of swan_fileinfo
-- ----------------------------
BEGIN;
INSERT INTO `swan_fileinfo` (`file_id`, `file_name`, `file_url`, `file_size`, `file_final_name`, `file_suffix`, `app_code`, `app_name`, `create_time`, `create_user`, `update_time`, `update_user`, `del_flag`) VALUES (1321985150420738050, 'icon.jpg', NULL, 29515.00, '1321985150332657666.jpg', '.jpg', 'none', NULL, '2020-10-30 09:19:56', 1184285445204418561, '2020-10-30 09:19:56', 1184285445204418561, 'N');
INSERT INTO `swan_fileinfo` (`file_id`, `file_name`, `file_url`, `file_size`, `file_final_name`, `file_suffix`, `app_code`, `app_name`, `create_time`, `create_user`, `update_time`, `update_user`, `del_flag`) VALUES (1321991534843486210, 'b92f9e749e6e40d499e539b43ddc4314.jpeg', NULL, 79202.00, '1321991534776377346.jpeg', '.jpeg', 'none', NULL, '2020-10-30 09:45:18', 1321991053345775618, '2020-10-30 09:45:18', 1321991053345775618, 'N');
INSERT INTO `swan_fileinfo` (`file_id`, `file_name`, `file_url`, `file_size`, `file_final_name`, `file_suffix`, `app_code`, `app_name`, `create_time`, `create_user`, `update_time`, `update_user`, `del_flag`) VALUES (1321998936368177154, 'icon2.jpg', NULL, 26199.00, '1321998936271708162.jpg', '.jpg', 'none', NULL, '2020-10-30 10:14:43', 1321998412927426561, '2020-10-30 10:14:43', 1321998412927426561, 'N');
COMMIT;

-- ----------------------------
-- Table structure for swan_sys_button
-- ----------------------------
DROP TABLE IF EXISTS `swan_sys_button`;
CREATE TABLE `swan_sys_button`  (
  `button_id` bigint(20) NOT NULL COMMENT '按钮id',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单id',
  `res_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '资源编码',
  `res_code_str` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源编码的字符串(前端需要)',
  `button_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮名称',
  `button_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '按钮编码',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮描述',
  `status` int(1) NOT NULL COMMENT '按钮状态(1:启用 2:禁用)',
  `order_no` decimal(11, 2) NOT NULL COMMENT '按钮排序',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`button_id`) USING BTREE,
  UNIQUE INDEX `button_code`(`button_code`) USING BTREE COMMENT '按钮编码'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '按钮表';

-- ----------------------------
-- Records of swan_sys_button
-- ----------------------------
BEGIN;
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1322107742735511554, 1183303686608302082, 'swan-cloud-system$dict$add_dict_type', 'Dict,swan-cloud-system$dict$add_dict_type', '新增字典', 'dictAdd', '新增字典', 1, 1.00, 1184285445204418561, '2020-10-30 17:27:04', 1184285445204418561, '2020-11-06 11:49:51');
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324285063403896834, 1177114395367141378, 'swan-cloud-system$ent_dept$add', 'EntDept,swan-cloud-system$ent_dept$add', '新增部门', 'deptAdd', '新增部门', 1, 2.00, 1184285445204418561, '2020-11-05 17:38:58', 1184285445204418561, '2020-11-06 13:11:43');
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324537709842903042, 1177113931707805697, 'swan-cloud-system$sys_button$query_list_page', 'SysButton,swan-cloud-system$sys_button$query_list_page', '按钮维护', 'btnMaintain', '按钮维护', 1, 3.00, 1184285445204418561, '2020-11-06 10:22:53', 1184285445204418561, '2020-11-06 13:07:20');
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324537979633119234, 1177113931707805697, 'swan-cloud-system$menu$add_menu', 'Menu,swan-cloud-system$menu$add_menu', '新增菜单', 'menuAdd', '新增菜单', 1, 4.00, 1184285445204418561, '2020-11-06 10:23:58', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324538129478823937, 1177113931707805697, 'swan-cloud-system$menu$delete_menu', 'Menu,swan-cloud-system$menu$delete_menu', '删除菜单', 'menuDel', '删除菜单', 1, 5.00, 1184285445204418561, '2020-11-06 10:24:33', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324538233535311873, 1177113931707805697, 'swan-cloud-system$menu$edit_menu', 'Menu,swan-cloud-system$menu$edit_menu', '编辑菜单', 'menuEdit', '编辑菜单', 1, 6.00, 1184285445204418561, '2020-11-06 10:24:58', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324538363353214977, 1177113931707805697, 'swan-cloud-system$menu$enable_menu', 'Menu,swan-cloud-system$menu$enable_menu', '禁用菜单', 'menuDisable', '禁用菜单', 1, 7.00, 1184285445204418561, '2020-11-06 10:25:29', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324538656547647489, 1177113931707805697, 'swan-cloud-system$menu$enable_menu', 'Menu,swan-cloud-system$menu$enable_menu', '启用菜单', 'menuEnable', '启用菜单', 1, 8.00, 1184285445204418561, '2020-11-06 10:26:39', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324545930733268994, 1203630856036442114, 'swan-cloud-system$res_cache$add_res_cache', 'ResCache,swan-cloud-system$res_cache$add_res_cache', '新增资源', 'resourceAdd', '新增资源部', 1, 9.00, 1184285445204418561, '2020-11-06 10:55:33', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324546079144521730, 1203630856036442114, 'swan-cloud-system$res_cache$get_detail', 'ResCache,swan-cloud-system$res_cache$get_detail', '资源详情', 'resourceDetail', '资源详情', 1, 10.00, 1184285445204418561, '2020-11-06 10:56:09', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324546331029254146, 1203630856036442114, 'swan-cloud-system$res_cache$edit_res_cache', 'ResCache,swan-cloud-system$res_cache$edit_res_cache', '资源修改', 'resourceEdit', '资源修改', 1, 11.00, 1184285445204418561, '2020-11-06 10:57:09', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324546466673045506, 1203630856036442114, 'swan-cloud-system$res_cache$remove_res_cache', 'ResCache,swan-cloud-system$res_cache$remove_res_cache', '资源删除', 'resourceDel', '资源删除', 1, 12.00, 1184285445204418561, '2020-11-06 10:57:41', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324547034992848898, 1177113716217049089, 'swan-cloud-system$permission$add_permission', 'Permission,swan-cloud-system$permission$add_permission', '新增权限', 'permAdd', '新增权限', 1, 13.00, 1184285445204418561, '2020-11-06 10:59:57', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324547668001402881, 1177113716217049089, 'swan-cloud-system$permission$set_permission_status', 'Permission,swan-cloud-system$permission$set_permission_status', '批量启用', 'permBatchEnable', '批量启用', 1, 14.00, 1184285445204418561, '2020-11-06 11:02:28', 1184285445204418561, '2020-11-06 11:04:00');
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324547985396969473, 1177113716217049089, 'swan-cloud-system$permission$set_permission_status', 'Permission,swan-cloud-system$permission$set_permission_status', '批量禁用', 'permBatchDisable', '批量禁用', 1, 15.00, 1184285445204418561, '2020-11-06 11:03:43', 1184285445204418561, '2020-11-06 11:03:53');
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324552321468444673, 1177113716217049089, 'swan-cloud-system$permission$remove_permission', 'Permission,swan-cloud-system$permission$remove_permission', '权限删除', 'permDel', '权限删除', 1, 16.00, 1184285445204418561, '2020-11-06 11:20:57', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324553549472575489, 1177113716217049089, 'swan-cloud-system$permission$permission_bind_resource', 'Permission,swan-cloud-system$permission$permission_bind_resource', '绑定资源', 'permBindResource', '绑定资源', 1, 17.00, 1184285445204418561, '2020-11-06 11:25:50', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324554206875201537, 1177113716217049089, 'swan-cloud-system$permission$set_permission_status', 'Permission,swan-cloud-system$permission$set_permission_status', '权限禁用', 'permDisable', '权限禁用', 1, 18.00, 1184285445204418561, '2020-11-06 11:28:27', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324554354661502977, 1177113716217049089, 'swan-cloud-system$permission$set_permission_status', 'Permission,swan-cloud-system$permission$set_permission_status', '权限启用', 'permEnable', '权限启用', 1, 19.00, 1184285445204418561, '2020-11-06 11:29:02', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324555014408744962, 1177098192292593666, 'swan-cloud-system$role$add_role', 'Role,swan-cloud-system$role$add_role', '新增角色 ', 'roleAdd', '新增角色', 1, 20.00, 1184285445204418561, '2020-11-06 11:31:39', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324555820855963650, 1177098192292593666, 'swan-cloud-system$role$find_role_detail', 'Role,swan-cloud-system$role$find_role_detail', '角色详情', 'roleDetail', '角色详情', 1, 21.00, 1184285445204418561, '2020-11-06 11:34:51', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324556775898984449, 1177098192292593666, 'swan-cloud-system$role$set_status', 'Role,swan-cloud-system$role$set_status', '角色禁用', 'roleDisable', '角色禁用', 1, 22.00, 1184285445204418561, '2020-11-06 11:38:39', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324556870027554818, 1177098192292593666, 'swan-cloud-system$role$set_status', 'Role,swan-cloud-system$role$set_status', '角色启用', 'roleEnable', '角色启用', 1, 23.00, 1184285445204418561, '2020-11-06 11:39:02', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324557686876647426, 1177098192292593666, 'swan-cloud-system$role$update_role', 'Role,swan-cloud-system$role$update_role', '角色编辑', 'roleEdit', '角色编辑', 1, 24.00, 1184285445204418561, '2020-11-06 11:42:16', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324557782146068482, 1177098192292593666, 'swan-cloud-system$role$delete_role', 'Role,swan-cloud-system$role$delete_role', '角色删除', 'roleDel', '角色删除', 1, 25.00, 1184285445204418561, '2020-11-06 11:42:39', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324557906272301057, 1177098192292593666, 'swan-cloud-system$role$assign_permission', 'Role,swan-cloud-system$role$assign_permission', '分配权限', 'roleConfigPerm', '分配权限', 1, 26.00, 1184285445204418561, '2020-11-06 11:43:09', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324559799203639298, 1183303686608302082, 'swan-cloud-system$dict$update_dict', 'Dict,swan-cloud-system$dict$update_dict', '编辑字典', 'dictEdit', '编辑字典', 1, 27.00, 1184285445204418561, '2020-11-06 11:50:40', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324559895609716737, 1183303686608302082, 'swan-cloud-system$dict$delete_dict', 'Dict,swan-cloud-system$dict$delete_dict', '删除字典', 'dictDel', '删除字典', 1, 28.00, 1184285445204418561, '2020-11-06 11:51:03', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324560059720249346, 1183303686608302082, 'swan-cloud-system$dict$update_dict_status', 'Dict,swan-cloud-system$dict$update_dict_status', '禁用字典', 'dictDisable', '禁用字典', 1, 29.00, 1184285445204418561, '2020-11-06 11:51:42', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324560511627145217, 1183303686608302082, 'swan-cloud-system$dict$update_dict_status', 'Dict,swan-cloud-system$dict$update_dict_status', '启用字典', 'dictEnable', '启用字典', 1, 30.00, 1184285445204418561, '2020-11-06 11:53:30', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324578019478319105, 1183303686608302082, 'swan-cloud-system$dict$get_dict_page', 'Dict,swan-cloud-system$dict$get_dict_page', '字典管理', 'dictManage', '字典管理', 1, 31.00, 1184285445204418561, '2020-11-06 13:03:04', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324580317952716802, 1177114395367141378, 'swan-cloud-system$ent_dept$detail', 'EntDept,swan-cloud-system$ent_dept$detail', '部门详情', 'deptDetail', '部门详情', 1, 32.00, 1184285445204418561, '2020-11-06 13:12:12', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324580692025913345, 1177114395367141378, 'swan-cloud-system$ent_dept$update', 'EntDept,swan-cloud-system$ent_dept$update', '编辑编辑', 'deptEdit', '部门编辑', 1, 33.00, 1184285445204418561, '2020-11-06 13:13:41', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324580844170096642, 1177114395367141378, 'swan-cloud-system$ent_dept$delete', 'EntDept,swan-cloud-system$ent_dept$delete', '部门删除', 'deptDel', '部门删除', 1, 34.00, 1184285445204418561, '2020-11-06 13:14:17', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324580995961958402, 1177114395367141378, 'swan-cloud-system$ent_dept$change_status', 'EntDept,swan-cloud-system$ent_dept$change_status', '部门启用', 'deptEnable', '部门启用', 1, 35.00, 1184285445204418561, '2020-11-06 13:14:54', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324581083178315777, 1177114395367141378, 'swan-cloud-system$ent_dept$change_status', 'EntDept,swan-cloud-system$ent_dept$change_status', '部门禁用', 'deptDisable', '部门禁用', 1, 36.00, 1184285445204418561, '2020-11-06 13:15:14', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324581439648018433, 1177114554092187649, 'swan-cloud-system$ent_user$add', 'EntUser,swan-cloud-system$ent_user$add', '人员新增', 'personAdd', '人员新增', 1, 37.00, 1184285445204418561, '2020-11-06 13:16:39', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324581552588042242, 1177114554092187649, 'swan-cloud-system$ent_user$detail', 'EntUser,swan-cloud-system$ent_user$detail', '人员详情', 'personDetail', '人员详情', 1, 38.00, 1184285445204418561, '2020-11-06 13:17:06', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324581663707738113, 1177114554092187649, 'swan-cloud-system$ent_user$update', 'EntUser,swan-cloud-system$ent_user$update', '人员编辑', 'personEdit', '人员编辑', 1, 39.00, 1184285445204418561, '2020-11-06 13:17:33', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324581768640835585, 1177114554092187649, 'swan-cloud-system$ent_user$change_status', 'EntUser,swan-cloud-system$ent_user$change_status', '人员禁用', 'personDisable', '人员禁用', 1, 40.00, 1184285445204418561, '2020-11-06 13:17:58', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324581886567886850, 1177114554092187649, 'swan-cloud-system$ent_user$change_status', 'EntUser,swan-cloud-system$ent_user$change_status', '人员启用', 'personEnable', '人员启用', 1, 41.00, 1184285445204418561, '2020-11-06 13:18:26', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324582022043906050, 1177114554092187649, 'swan-cloud-system$ent_user$get_roles', 'EntUser,swan-cloud-system$ent_user$get_roles', '配置角色', 'personConfig', '配置角色', 1, 42.00, 1184285445204418561, '2020-11-06 13:18:58', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324582127245438978, 1177114554092187649, 'swan-cloud-system$ent_user$delete', 'EntUser,swan-cloud-system$ent_user$delete', '人员删除', 'personDel', '人员删除', 1, 43.00, 1184285445204418561, '2020-11-06 13:19:23', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324582214461796354, 1177114554092187649, 'swan-cloud-system$ent_user$update_password', 'EntUser,swan-cloud-system$ent_user$update_password', '重置密码', 'resetPwd', '重置密码', 1, 44.00, 1184285445204418561, '2020-11-06 13:19:44', NULL, NULL);
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324582655417364482, 1183302416396931073, 'swan-cloud-system$ent_duty$add', 'EntDuty,swan-cloud-system$ent_duty$add', '职位新增', 'dutyAdd', '职位新增', 1, 45.00, 1184285445204418561, '2020-11-06 13:21:29', 1184285445204418561, '2020-11-06 13:24:57');
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324582743053152258, 1183302416396931073, 'swan-cloud-system$ent_duty$detail', 'EntDuty,swan-cloud-system$ent_duty$detail', '职位详情', 'dutyDetail', '职位详情', 1, 46.00, 1184285445204418561, '2020-11-06 13:21:50', 1184285445204418561, '2020-11-06 13:25:05');
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324582818265411585, 1183302416396931073, 'swan-cloud-system$ent_duty$change_status', 'EntDuty,swan-cloud-system$ent_duty$change_status', '职位禁用', 'dutyDisable', '职位禁用', 1, 47.00, 1184285445204418561, '2020-11-06 13:22:08', 1184285445204418561, '2020-11-06 13:25:13');
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324582899748155394, 1183302416396931073, 'swan-cloud-system$ent_duty$change_status', 'EntDuty,swan-cloud-system$ent_duty$change_status', '职位启用', 'dutyEnable', '职位启用', 1, 48.00, 1184285445204418561, '2020-11-06 13:22:28', 1184285445204418561, '2020-11-06 13:25:23');
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324582981327368193, 1183302416396931073, 'swan-cloud-system$ent_duty$update', 'EntDuty,swan-cloud-system$ent_duty$update', '职位编辑', 'dutyEdit', '职位编辑', 1, 49.00, 1184285445204418561, '2020-11-06 13:22:47', 1184285445204418561, '2020-11-06 13:25:37');
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324583080518463490, 1183302416396931073, 'swan-cloud-system$ent_duty$delete', 'EntDuty,swan-cloud-system$ent_duty$delete', '职位删除', 'dutyDel', '职位删除', 1, 50.00, 1184285445204418561, '2020-11-06 13:23:11', 1184285445204418561, '2020-11-06 13:25:30');
INSERT INTO `swan_sys_button` (`button_id`, `menu_id`, `res_code`, `res_code_str`, `button_name`, `button_code`, `description`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1324636534313132034, 1289579421908369410, 'swan-cloud-system$sys_op_log$delete', 'SysLog,swan-cloud-system$sys_op_log$delete', '清空业务日志', 'bizLogClear', '清空业务日志', 1, 51.00, 1184285445204418561, '2020-11-06 16:55:35', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for swan_sys_database_info
-- ----------------------------
DROP TABLE IF EXISTS `swan_sys_database_info`;
CREATE TABLE `swan_sys_database_info`  (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `db_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据库名称（英文名称）',
  `jdbc_driver` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'jdbc的驱动类型',
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据库连接的账号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据库连接密码',
  `jdbc_url` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'jdbc的url',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注，摘要',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `NAME_UNIQUE`(`db_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '数据库信息表';

-- ----------------------------
-- Records of swan_sys_database_info
-- ----------------------------
BEGIN;
INSERT INTO `swan_sys_database_info` (`id`, `db_name`, `jdbc_driver`, `user_name`, `password`, `jdbc_url`, `remarks`, `create_time`) VALUES (1331487775909789697, 'master', 'com.mysql.cj.jdbc.Driver', 'root', 'XNewTech@249', 'jdbc:mysql://192.168.9.249:3306/swan_cloud_system?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=CTT', '主数据源，项目启动数据源！', '2020-11-25 14:39:58');
COMMIT;

-- ----------------------------
-- Table structure for swan_sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `swan_sys_dict`;
CREATE TABLE `swan_sys_dict`  (
  `dict_id` bigint(20) NOT NULL COMMENT '字典id',
  `dict_type_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典类型编码',
  `dict_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典编码',
  `dict_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典名称',
  `dict_short_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
  `dict_short_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典简拼',
  `parent_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '上级代码id',
  `status` smallint(6) NOT NULL COMMENT '状态(1:启用,2:禁用)',
  `order_no` decimal(11, 2) NULL DEFAULT NULL COMMENT '排序',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `del_flag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`dict_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '基础字典';

-- ----------------------------
-- Records of swan_sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `swan_sys_dict` (`dict_id`, `dict_type_code`, `dict_code`, `dict_name`, `dict_short_name`, `dict_short_code`, `parent_id`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1183726300989239311, 'APP_TYPE', 'INSIDE', '内部', '内部', NULL, '-1', 1, 1.00, NULL, NULL, NULL, NULL, 'N');
INSERT INTO `swan_sys_dict` (`dict_id`, `dict_type_code`, `dict_code`, `dict_name`, `dict_short_name`, `dict_short_code`, `parent_id`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1183726300989239411, 'APP_TYPE', 'OUTSIDE', '外部', '外部', NULL, '-1', 1, 1.00, NULL, NULL, NULL, NULL, 'N');
INSERT INTO `swan_sys_dict` (`dict_id`, `dict_type_code`, `dict_code`, `dict_name`, `dict_short_name`, `dict_short_code`, `parent_id`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1183727344871858177, 'EDUCATION', 'REGULAR', '硕士', '硕士', 'ss', '1183727829133664258', 1, 30.00, -1, '2019-10-14 20:54:10', 1184285445204418561, '2020-10-30 13:57:21', 'N');
INSERT INTO `swan_sys_dict` (`dict_id`, `dict_type_code`, `dict_code`, `dict_name`, `dict_short_name`, `dict_short_code`, `parent_id`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1183727829133664258, 'EDUCATION', 'MASTER', '研究生', 'yjs', 'yjs', '-1', 1, 1.00, -1, '2019-10-14 20:55:54', 1184285445204418561, '2020-10-30 13:55:22', 'N');
INSERT INTO `swan_sys_dict` (`dict_id`, `dict_type_code`, `dict_code`, `dict_name`, `dict_short_name`, `dict_short_code`, `parent_id`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1183728219208093697, 'MARITAL', 'MARRIED', '已婚', 'y', 'yh', '-1', 1, 1.00, -1, '2019-10-14 20:57:14', 1321991053345775618, '2020-10-30 14:51:46', 'N');
INSERT INTO `swan_sys_dict` (`dict_id`, `dict_type_code`, `dict_code`, `dict_name`, `dict_short_name`, `dict_short_code`, `parent_id`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1183728535072669697, 'MARITAL', 'SPINSTERHOOD', '未婚', 'w', 'wh', '-1', 1, 1.00, -1, '2019-10-14 20:58:56', 1321991053345775618, '2020-10-30 14:51:34', 'N');
INSERT INTO `swan_sys_dict` (`dict_id`, `dict_type_code`, `dict_code`, `dict_name`, `dict_short_name`, `dict_short_code`, `parent_id`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1183729049877463041, 'POLICY', 'PARTY', '党员', '党员', NULL, '-1', 1, 1.00, -1, '2019-10-14 21:00:30', NULL, NULL, 'N');
INSERT INTO `swan_sys_dict` (`dict_id`, `dict_type_code`, `dict_code`, `dict_name`, `dict_short_name`, `dict_short_code`, `parent_id`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1183729632801746946, 'POLICY', 'MASSES', '群众', '群众', NULL, '-1', 1, 1.00, -1, '2019-10-14 21:02:52', NULL, NULL, 'N');
INSERT INTO `swan_sys_dict` (`dict_id`, `dict_type_code`, `dict_code`, `dict_name`, `dict_short_name`, `dict_short_code`, `parent_id`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1321369478214938626, 'EDUCATION', 'benke', '本科', '本科', 'bk', '-1', 1, 2.00, 1184285445204418561, '2020-10-28 16:33:28', 1184285445204418561, '2020-10-30 13:51:33', 'N');
INSERT INTO `swan_sys_dict` (`dict_id`, `dict_type_code`, `dict_code`, `dict_name`, `dict_short_name`, `dict_short_code`, `parent_id`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1322054699342061570, 'EDUCATION', 'bs', '博士', 'bss', 'bsss', '1183727829133664258', 1, 10.00, 1321991053345775618, '2020-10-30 13:56:18', 1321991053345775618, '2020-10-30 13:56:52', 'N');
INSERT INTO `swan_sys_dict` (`dict_id`, `dict_type_code`, `dict_code`, `dict_name`, `dict_short_name`, `dict_short_code`, `parent_id`, `status`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1328990862354423810, 'MARITAL', 'LIYIMERRY', '离异', 'LY', 'LY', '-1', 1, 4.00, 1184285445204418561, '2020-11-18 17:18:08', NULL, NULL, 'N');
COMMIT;

-- ----------------------------
-- Table structure for swan_sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `swan_sys_dict_type`;
CREATE TABLE `swan_sys_dict_type`  (
  `dict_type_id` bigint(20) NOT NULL COMMENT '字典类型id',
  `dict_type_class` smallint(1) NULL DEFAULT NULL COMMENT '类型1：业务类型2：系统类型',
  `dict_type_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典类型编码',
  `dict_type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典类型名称',
  `dict_type_desc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典描述',
  `status` smallint(11) NOT NULL DEFAULT 1 COMMENT '状态1：启用2：禁用',
  `app_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用编码',
  `order_no` decimal(11, 2) NULL DEFAULT NULL COMMENT '排序',
  `create_user` bigint(11) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
  `update_user` bigint(11) NULL DEFAULT NULL COMMENT '修改人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '删除标记',
  PRIMARY KEY (`dict_type_id`) USING BTREE,
  UNIQUE INDEX `CODE_UNI`(`dict_type_code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典类型表';

-- ----------------------------
-- Records of swan_sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `swan_sys_dict_type` (`dict_type_id`, `dict_type_class`, `dict_type_code`, `dict_type_name`, `dict_type_desc`, `status`, `app_code`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1183725058342834178, 1, 'EDUCATION', '学历', '学历', 1, NULL, 1.00, 1, '2019-10-14 20:46:26', 1184285445204418561, '2019-10-18 13:20:57', 'N');
INSERT INTO `swan_sys_dict_type` (`dict_type_id`, `dict_type_class`, `dict_type_code`, `dict_type_name`, `dict_type_desc`, `status`, `app_code`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1183725998110265346, 1, 'MARITAL', '婚姻状况', '婚姻状况', 1, NULL, 2.00, 1, '2019-10-14 20:48:20', NULL, NULL, 'N');
INSERT INTO `swan_sys_dict_type` (`dict_type_id`, `dict_type_class`, `dict_type_code`, `dict_type_name`, `dict_type_desc`, `status`, `app_code`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1183726300989239298, 1, 'POLICY', '政治面貌', '政治面貌', 1, NULL, 3.00, 1, '2019-10-14 20:49:21', NULL, NULL, 'N');
INSERT INTO `swan_sys_dict_type` (`dict_type_id`, `dict_type_class`, `dict_type_code`, `dict_type_name`, `dict_type_desc`, `status`, `app_code`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1183726300989239310, 1, 'APP_TYPE', '应用类型', '应用类型', 1, NULL, 4.00, 1, NULL, 1184285445204418561, '2020-10-28 16:55:35', 'N');
INSERT INTO `swan_sys_dict_type` (`dict_type_id`, `dict_type_class`, `dict_type_code`, `dict_type_name`, `dict_type_desc`, `status`, `app_code`, `order_no`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1321326351563276289, 0, '555', '55', '555', 1, NULL, 0.00, 1184285445204418561, '2020-10-28 13:42:06', NULL, NULL, 'N');
COMMIT;

-- ----------------------------
-- Table structure for swan_sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `swan_sys_menu`;
CREATE TABLE `swan_sys_menu`  (
  `menu_id` bigint(20) NOT NULL COMMENT '菜单id',
  `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单编码',
  `pid` bigint(20) NULL DEFAULT NULL COMMENT '菜单父id',
  `icon` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
  `res_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源code',
  `menu_tips` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单提示',
  `hidden_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '是否隐藏',
  `order_no` decimal(11, 2) NULL DEFAULT NULL COMMENT '排序编号',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求地址',
  `status` int(11) NULL DEFAULT 1 COMMENT '菜单状态(1:启用,2:禁用)',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`menu_id`) USING BTREE,
  UNIQUE INDEX `CODE_UNI`(`code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单';

-- ----------------------------
-- Records of swan_sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1177096712667971585, '资源权限', 'resourcePermission', 1177097856710524930, 'icon-keystroke', 'swan-cloud-system$authority_menu_flag$authority_menu', '', 'N', 10.00, 'systemManage/resourcePermission', 1, 1, '2019-09-26 13:45:00', 1184285445204418561, '2020-10-25 15:07:38');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1177097020781543426, '组织架构', 'orgBuild', 1177097856710524930, 'icon-department1', 'swan-cloud-system$ent_menu_flag$system', '', 'N', 3.00, 'systemManage/orgBuild', 1, 1, '2019-09-26 13:46:14', 1184285445204418561, '2020-10-25 14:45:46');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1177097856710524930, '系统管理', 'systemManage', -1, 'icon-system', 'swan-cloud-system$system_menu_flag$system', '设置机构、人员和权限、日志查看', 'N', 0.00, 'Layout', 1, 1, '2019-09-26 13:49:33', 1184285445204418561, '2020-11-20 14:20:58');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1177098192292593666, '角色管理', 'roleManage', 1177096712667971585, 'icon-mg-role', 'swan-cloud-system$authority_menu_flag$role_manager', '', 'N', 13.00, 'systemManage/resourcePermission/roleManage', 1, 1, '2019-09-26 13:50:53', 1184285445204418561, '2020-11-06 14:42:53');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1177113716217049089, '权限管理', 'permissionManage', 1177096712667971585, 'icon-accountauthority', 'swan-cloud-system$authority_menu_flag$permission_manager', '', 'N', 13.00, 'systemManage/resourcePermission/permissionManage', 1, 1, '2019-09-26 14:52:34', 1184285445204418561, '2020-11-06 14:42:26');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1177113931707805697, '菜单管理', 'menuManage', 1177096712667971585, 'icon-menu', 'swan-cloud-system$authority_menu_flag$menu_manager', '', 'N', 14.00, 'systemManage/resourcePermission/menuManage', 1, 1, '2019-09-26 14:53:26', 1184285445204418561, '2020-11-06 14:43:12');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1177114395367141378, '部门管理', 'deptManage', 1177097020781543426, 'icon-department', 'swan-cloud-system$ent_menu_flag$dept', '', 'N', 22.00, 'systemManage/orgBuild/deptManage', 1, 1, '2019-09-26 14:55:16', 1184285445204418561, '2020-10-25 13:39:09');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1177114554092187649, '人员管理', 'personManage', 1177097020781543426, 'icon-geren', 'swan-cloud-system$ent_menu_flag$personal', '', 'N', 23.00, 'systemManage/orgBuild/personManage', 1, 1, '2019-09-26 14:55:54', 1184285445204418561, '2020-10-25 13:44:42');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1183302416396931073, '职位管理', 'dutyManage', 1177097020781543426, 'icon-position', 'swan-cloud-system$ent_menu_flag$duty', '', 'N', 24.00, 'systemManage/orgBuild/dutyManage', 1, 1, '2019-10-13 08:44:15', 1184285445204418561, '2020-10-25 13:45:25');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1183303686608302082, '字典管理', 'dictManage', 1177097856710524930, 'icon-dictionary', 'swan-cloud-system$system_menu_flag$dic_manager', '', 'N', 32.00, 'systemManage/dictManage', 1, 1, '2019-10-13 08:49:18', 1184285445204418561, '2019-10-31 13:35:29');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1203630856036442114, '资源维护', 'resourceMaintain', 1177096712667971585, 'icon-config', 'swan-cloud-system$authority_menu_flag$res_maintain', '', 'N', 11.00, 'Layout', 1, 1184285445204418561, '2019-12-08 11:02:13', 1184285445204418561, '2020-11-06 15:04:46');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1289579318623633410, '日志管理', 'logManager', 1177097856710524930, 'icon-rizhi', 'swan-cloud-system$log_menu_flag$logs_menu', '', 'N', 31.00, 'systemManage/logManager', 1, 1184285445204418561, '2020-08-01 23:10:43', 1184285445204418561, '2020-10-25 15:14:51');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1289579421908369410, '业务日志', 'bizLog', 1289579318623633410, 'icon-wj-rz', 'swan-cloud-system$log_menu_flag$biz_menu', '', 'N', 0.00, 'systemManage/logManager/logManager', 1, 1184285445204418561, '2020-08-01 23:11:08', 1184285445204418561, '2020-10-25 15:00:00');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1289579582768316418, '登录日志', 'sysLoginLog', 1289579318623633410, 'icon-system', 'swan-cloud-system$log_menu_flag$login_menu', '222', 'N', 1.00, 'systemManage/logManager/sysLoginLog', 1, 1184285445204418561, '2020-08-01 23:11:46', 1321991053345775618, '2020-11-16 17:47:30');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1329670385011879938, '业务组件', 'business-component', -1, 'icon-app', 'swan-cloud-system$authority_menu_flag$authority_menu', '', 'N', 2.00, '', 2, 1184285445204418561, '2020-11-20 14:18:19', 1184285445204418561, '2020-11-23 13:19:40');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1329702047722774530, '测试菜单A', 'testA', -1, 'icon-department', 'swan-cloud-system$authority_menu_flag$menu_manager', '', 'N', 4.00, '', 2, 1184285445204418561, '2020-11-20 16:24:07', 1184285445204418561, '2020-11-23 13:27:19');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1329702432606613505, '测试菜单B', 'testB', -1, 'icon-department', 'swan-cloud-system$authority_menu_flag$permission_manager', '', 'N', 5.00, '', 2, 1184285445204418561, '2020-11-20 16:25:39', 1184285445204418561, '2020-11-23 13:19:42');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1329710812375293953, '测试菜单C', 'testC', -1, 'icon-department', 'swan-cloud-system$authority_menu_flag$role_manager', NULL, 'N', 6.00, NULL, 2, 1184285445204418561, '2020-11-20 16:58:57', 1184285445204418561, '2020-11-23 13:22:56');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1329753969419530241, '测试菜单D', 'testD', -1, 'icon-department', 'swan-cloud-system$authority_menu_flag$menu_manager', '', 'N', 7.00, '', 2, 1184285445204418561, '2020-11-20 19:50:27', 1184285445204418561, '2020-11-23 13:22:54');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1329754282376830978, '测试菜单E', 'testE', -1, 'icon-department', 'swan-cloud-system$authority_menu_flag$menu_manager', NULL, 'N', 9.00, NULL, 2, 1184285445204418561, '2020-11-20 19:51:41', 1184285445204418561, '2020-11-23 13:22:53');
INSERT INTO `swan_sys_menu` (`menu_id`, `name`, `code`, `pid`, `icon`, `res_code`, `menu_tips`, `hidden_flag`, `order_no`, `url`, `status`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES (1329754418809151490, '测试菜单F', 'testF', -1, 'icon-department', 'swan-cloud-system$authority_menu_flag$res_maintain', NULL, 'N', 9.00, NULL, 2, 1184285445204418561, '2020-11-20 19:52:14', 1184285445204418561, '2020-11-23 13:22:49');
COMMIT;

-- ----------------------------
-- Table structure for swan_sys_op_log
-- ----------------------------
DROP TABLE IF EXISTS `swan_sys_op_log`;
CREATE TABLE `swan_sys_op_log`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `op_type` tinyint(4) NULL DEFAULT NULL COMMENT '操作类型',
  `success` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否执行成功（Y-是，N-否）',
  `message` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '具体消息',
  `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ip',
  `location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `browser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '浏览器',
  `os` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作系统',
  `url` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求地址',
  `class_name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类名称',
  `method_name` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '方法名称',
  `req_method` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求方式（GET POST PUT DELETE)',
  `param` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '请求参数',
  `op_time` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
  `account` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作账号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统操作日志表';

-- ----------------------------
-- Table structure for swan_sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `swan_sys_permission`;
CREATE TABLE `swan_sys_permission`  (
  `permission_id` bigint(20) NOT NULL COMMENT '主键id',
  `permission_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限名称',
  `permission_desc` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限描述',
  `order_no` decimal(11, 2) NULL DEFAULT NULL COMMENT '排序编号',
  `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父级id',
  `status` int(11) NULL DEFAULT 1 COMMENT '权限状态(1:启用,2:禁用)',
  `create_user` bigint(32) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(32) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '删除标记(Y:已删除 N:未删除)',
  PRIMARY KEY (`permission_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限表';

-- ----------------------------
-- Records of swan_sys_permission
-- ----------------------------
BEGIN;
INSERT INTO `swan_sys_permission` (`permission_id`, `permission_name`, `permission_desc`, `order_no`, `parent_id`, `status`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1184285448379506690, '系统管理员权限', NULL, NULL, -1, 1, -100, '2019-10-16 01:50:29', 1184285445204418561, '2020-08-02 10:20:01', 'N');
INSERT INTO `swan_sys_permission` (`permission_id`, `permission_name`, `permission_desc`, `order_no`, `parent_id`, `status`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1321260470447513601, '测试权限', '测试', NULL, -1, 1, 1184285445204418561, '2020-10-28 09:20:19', 1321991053345775618, '2020-11-16 17:20:02', 'N');
INSERT INTO `swan_sys_permission` (`permission_id`, `permission_name`, `permission_desc`, `order_no`, `parent_id`, `status`, `create_user`, `create_time`, `update_user`, `update_time`, `del_flag`) VALUES (1322051793364672513, '区域管理员', '二级管理员', NULL, -1, 1, 1321991053345775618, '2020-10-30 13:44:45', NULL, NULL, 'N');
COMMIT;

-- ----------------------------
-- Table structure for swan_sys_permission_resource
-- ----------------------------
DROP TABLE IF EXISTS `swan_sys_permission_resource`;
CREATE TABLE `swan_sys_permission_resource`  (
  `permission_resource_id` bigint(20) NOT NULL COMMENT '权限资源id',
  `permission_id` bigint(20) NOT NULL COMMENT '权限ID',
  `resource_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '资源ID',
  PRIMARY KEY (`permission_resource_id`, `permission_id`, `resource_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限资源表';

-- ----------------------------
-- Records of swan_sys_permission_resource
-- ----------------------------
BEGIN;
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817217, 1184285448379506690, 'swan-cloud-system$dash_board$get_biz_statistics');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817218, 1184285448379506690, 'swan-cloud-system$dash_board$get_modules_statistics');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817219, 1184285448379506690, 'swan-cloud-system$dict$check_code');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817220, 1184285448379506690, 'swan-cloud-system$dict$update_dict');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817221, 1184285448379506690, 'swan-cloud-system$dict$delete_dict');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817222, 1184285448379506690, 'swan-cloud-system$dict$update_dict_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817223, 1184285448379506690, 'swan-cloud-system$dict$get_list_by_type_code_and_PC_ode');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817224, 1184285448379506690, 'swan-cloud-system$dict$get_dict_list_by_type_code');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817225, 1184285448379506690, 'swan-cloud-system$dict$add_dict_type');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817226, 1184285448379506690, 'swan-cloud-system$dict$get_dict_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817227, 1184285448379506690, 'swan-cloud-system$dict$get_dict_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817228, 1184285448379506690, 'swan-cloud-system$dict$get_dict_tree_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817229, 1184285448379506690, 'swan-cloud-system$system_menu_flag$dic_manager');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817230, 1184285448379506690, 'swan-cloud-system$system_menu_flag$system');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663399817231, 1184285448379506690, 'swan-cloud-system$system$get_user_info');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788738, 1184285448379506690, 'swan-cloud-system$authority_menu_flag$permission_manager');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788739, 1184285448379506690, 'swan-cloud-system$authority_menu_flag$menu_manager');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788740, 1184285448379506690, 'swan-cloud-system$authority_menu_flag$role_manager');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788741, 1184285448379506690, 'swan-cloud-system$authority_menu_flag$authority_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788742, 1184285448379506690, 'swan-cloud-system$authority_menu_flag$res_maintain');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788743, 1184285448379506690, 'swan-cloud-system$ent_duty$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788744, 1184285448379506690, 'swan-cloud-system$ent_duty$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788745, 1184285448379506690, 'swan-cloud-system$ent_duty$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788746, 1184285448379506690, 'swan-cloud-system$ent_duty$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788747, 1184285448379506690, 'swan-cloud-system$ent_duty$change_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788748, 1184285448379506690, 'swan-cloud-system$ent_duty$query_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788749, 1184285448379506690, 'swan-cloud-system$ent_duty$detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788750, 1184285448379506690, 'swan-cloud-system$ent_user_account$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788751, 1184285448379506690, 'swan-cloud-system$ent_user_account$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788752, 1184285448379506690, 'swan-cloud-system$ent_user_account$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788753, 1184285448379506690, 'swan-cloud-system$ent_user_account$query_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788754, 1184285448379506690, 'swan-cloud-system$ent_user_account$query_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788755, 1184285448379506690, 'swan-cloud-system$ent_user_account$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788756, 1184285448379506690, 'swan-cloud-system$ent_user_dept$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788757, 1184285448379506690, 'swan-cloud-system$ent_user_dept$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788758, 1184285448379506690, 'swan-cloud-system$ent_user_dept$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788759, 1184285448379506690, 'swan-cloud-system$ent_user_dept$query_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788760, 1184285448379506690, 'swan-cloud-system$ent_user_dept$query_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788761, 1184285448379506690, 'swan-cloud-system$ent_user_dept$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788762, 1184285448379506690, 'swan-cloud-system$file$upload');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788763, 1184285448379506690, 'swan-cloud-system$file$file_access');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788764, 1184285448379506690, 'swan-cloud-system$file$preview');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788765, 1184285448379506690, 'swan-cloud-system$permission$get_permission_list4_level');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788766, 1184285448379506690, 'swan-cloud-system$permission$get_permission_page_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788767, 1184285448379506690, 'swan-cloud-system$permission$add_permission');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788768, 1184285448379506690, 'swan-cloud-system$permission$set_permission_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788769, 1184285448379506690, 'swan-cloud-system$permission$remove_permission');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788770, 1184285448379506690, 'swan-cloud-system$permission$permission_bind_resource');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788771, 1184285448379506690, 'swan-cloud-system$permission$get_app_button_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788772, 1184285448379506690, 'swan-cloud-system$permission$get_permission_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788773, 1184285448379506690, 'swan-cloud-system$permission$get_permission_resource_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788774, 1184285448379506690, 'swan-cloud-system$permission$get_resource_list4_permission');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788775, 1184285448379506690, 'swan-cloud-system$permission$get_permission_resource_list_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663420788776, 1184285448379506690, 'swan-cloud-system$permission$cancel_permission_bind_resource');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371650, 1184285448379506690, 'swan-cloud-system$res_cache$edit_res_cache');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371651, 1184285448379506690, 'swan-cloud-system$res_cache$remove_res_cache');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371652, 1184285448379506690, 'swan-cloud-system$res_cache$add_res_cache');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371653, 1184285448379506690, 'swan-cloud-system$res_cache$get_http_request_select');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371654, 1184285448379506690, 'swan-cloud-system$res_cache$get_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371655, 1184285448379506690, 'swan-cloud-system$res_cache$get_res_module_select');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371656, 1184285448379506690, 'swan-cloud-system$res_cache$get_res_cache_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371657, 1184285448379506690, 'swan-cloud-system$ent_user$save_roles');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371658, 1184285448379506690, 'swan-cloud-system$ent_user$save_current_user');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371659, 1184285448379506690, 'swan-cloud-system$ent_user$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371660, 1184285448379506690, 'swan-cloud-system$ent_user$update_password');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371661, 1184285448379506690, 'swan-cloud-system$ent_user$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371662, 1184285448379506690, 'swan-cloud-system$ent_user$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371663, 1184285448379506690, 'swan-cloud-system$ent_user$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371664, 1184285448379506690, 'swan-cloud-system$ent_user$change_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371665, 1184285448379506690, 'swan-cloud-system$ent_user$get_company_select');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371666, 1184285448379506690, 'swan-cloud-system$ent_user$get_current_user');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371667, 1184285448379506690, 'swan-cloud-system$ent_user$get_roles');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371668, 1184285448379506690, 'swan-cloud-system$ent_user$query_info_by_dict_type');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371669, 1184285448379506690, 'swan-cloud-system$ent_user$get_duty_select');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371670, 1184285448379506690, 'swan-cloud-system$ent_user$get_dept_select');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371671, 1184285448379506690, 'swan-cloud-system$ent_user$detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371672, 1184285448379506690, 'swan-cloud-system$ent_user$reset_password');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371673, 1184285448379506690, 'swan-cloud-system$resource$get_resource_select_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371674, 1184285448379506690, 'swan-cloud-system$resource$resource_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371675, 1184285448379506690, 'swan-cloud-system$dict_type$check_code');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371676, 1184285448379506690, 'swan-cloud-system$dict_type$update_dict_type');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371677, 1184285448379506690, 'swan-cloud-system$dict_type$update_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371678, 1184285448379506690, 'swan-cloud-system$dict_type$delete_dict_type');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371679, 1184285448379506690, 'swan-cloud-system$dict_type$add_dict_type');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371680, 1184285448379506690, 'swan-cloud-system$dict_type$get_dict_type_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371681, 1184285448379506690, 'swan-cloud-system$ent_menu_flag$personal');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371682, 1184285448379506690, 'swan-cloud-system$ent_menu_flag$system');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371683, 1184285448379506690, 'swan-cloud-system$ent_menu_flag$duty');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371684, 1184285448379506690, 'swan-cloud-system$ent_menu_flag$dept');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371685, 1184285448379506690, 'swan-cloud-system$role$assign_permission');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371686, 1184285448379506690, 'swan-cloud-system$role$delete_role');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663433371687, 1184285448379506690, 'swan-cloud-system$role$update_role');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954562, 1184285448379506690, 'swan-cloud-system$role$select_role_by_account_id');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954563, 1184285448379506690, 'swan-cloud-system$role$find_role_all_permissions');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954564, 1184285448379506690, 'swan-cloud-system$role$find_permissions');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954565, 1184285448379506690, 'swan-cloud-system$role$validate_name');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954566, 1184285448379506690, 'swan-cloud-system$role$validate_code');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954567, 1184285448379506690, 'swan-cloud-system$role$add_role');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954568, 1184285448379506690, 'swan-cloud-system$role$find_all_role');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954569, 1184285448379506690, 'swan-cloud-system$role$get_all_res_permissions');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954570, 1184285448379506690, 'swan-cloud-system$role$get_all_res_permission_urls');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954571, 1184285448379506690, 'swan-cloud-system$role$find_role_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954572, 1184285448379506690, 'swan-cloud-system$role$find_role_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954573, 1184285448379506690, 'swan-cloud-system$role$set_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954574, 1184285448379506690, 'swan-cloud-system$sys_button$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954575, 1184285448379506690, 'swan-cloud-system$sys_button$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663445954576, 1184285448379506690, 'swan-cloud-system$sys_button$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148865, 1184285448379506690, 'swan-cloud-system$sys_button$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148866, 1184285448379506690, 'swan-cloud-system$sys_button$change_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148867, 1184285448379506690, 'swan-cloud-system$sys_button$get_button_permission');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148868, 1184285448379506690, 'swan-cloud-system$sys_button$get_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148869, 1184285448379506690, 'swan-cloud-system$sys_button$get_resources');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148870, 1184285448379506690, 'swan-cloud-system$menu$delete_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148871, 1184285448379506690, 'swan-cloud-system$menu$enable_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148872, 1184285448379506690, 'swan-cloud-system$menu$add_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148873, 1184285448379506690, 'swan-cloud-system$menu$edit_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148874, 1184285448379506690, 'swan-cloud-system$menu$get_left_menu_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148875, 1184285448379506690, 'swan-cloud-system$menu$get_select_menu_tree_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148876, 1184285448379506690, 'swan-cloud-system$menu$list_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148877, 1184285448379506690, 'swan-cloud-system$menu$get_menu_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148878, 1184285448379506690, 'swan-cloud-system$ent_dept$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148879, 1184285448379506690, 'swan-cloud-system$ent_dept$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148880, 1184285448379506690, 'swan-cloud-system$ent_dept$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148881, 1184285448379506690, 'swan-cloud-system$ent_dept$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663450148882, 1184285448379506690, 'swan-cloud-system$ent_dept$change_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663462731777, 1184285448379506690, 'swan-cloud-system$ent_dept$query_dept_tree');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663462731778, 1184285448379506690, 'swan-cloud-system$ent_dept$detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663462731779, 1184285448379506690, 'swan-cloud-system$log_menu_flag$biz_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663462731780, 1184285448379506690, 'swan-cloud-system$sys_log$op_log_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663462731781, 1184285448379506690, 'swan-cloud-system$sys_log$op_log_delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663462731782, 1184285448379506690, 'swan-cloud-system$log_menu_flag$logs_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663462731783, 1184285448379506690, 'swan-cloud-system$sys_op_log$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663462731784, 1184285448379506690, 'swan-cloud-system$log_menu_flag$login_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663462731785, 1184285448379506690, 'swan-cloud-system$sys_log$login_log_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1324605663462731786, 1184285448379506690, 'swan-cloud-system$sys_log$detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328287513451700225, 1321260470447513601, 'swan-cloud-system$system_menu_flag$system');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328287513451700226, 1321260470447513601, 'swan-cloud-system$ent_menu_flag$personal');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328287513451700227, 1321260470447513601, 'swan-cloud-system$ent_menu_flag$system');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328287513451700228, 1321260470447513601, 'swan-cloud-system$ent_menu_flag$duty');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328287513451700229, 1321260470447513601, 'swan-cloud-system$ent_menu_flag$dept');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328287513451700230, 1321260470447513601, 'swan-cloud-system$ent_dept$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328287513451700231, 1321260470447513601, 'swan-cloud-system$ent_dept$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328287513451700232, 1321260470447513601, 'swan-cloud-system$ent_dept$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328287513451700233, 1321260470447513601, 'swan-cloud-system$ent_dept$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328287513451700234, 1321260470447513601, 'swan-cloud-system$ent_dept$change_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328287513451700235, 1321260470447513601, 'swan-cloud-system$ent_dept$query_dept_tree');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328287513451700236, 1321260470447513601, 'swan-cloud-system$ent_dept$detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754625, 1322051793364672513, 'swan-cloud-system$dash_board$get_biz_statistics');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754626, 1322051793364672513, 'swan-cloud-system$dash_board$get_modules_statistics');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754627, 1322051793364672513, 'swan-cloud-system$dict$check_code');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754628, 1322051793364672513, 'swan-cloud-system$dict$update_dict');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754629, 1322051793364672513, 'swan-cloud-system$dict$delete_dict');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754630, 1322051793364672513, 'swan-cloud-system$dict$update_dict_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754631, 1322051793364672513, 'swan-cloud-system$dict$get_list_by_type_code_and_PC_ode');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754632, 1322051793364672513, 'swan-cloud-system$dict$get_dict_list_by_type_code');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754633, 1322051793364672513, 'swan-cloud-system$dict$add_dict_type');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754634, 1322051793364672513, 'swan-cloud-system$dict$get_dict_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754635, 1322051793364672513, 'swan-cloud-system$dict$get_dict_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754636, 1322051793364672513, 'swan-cloud-system$dict$get_dict_tree_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754637, 1322051793364672513, 'swan-cloud-system$system_menu_flag$system');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443177754638, 1322051793364672513, 'swan-cloud-system$system$get_user_info');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948930, 1322051793364672513, 'swan-cloud-system$authority_menu_flag$permission_manager');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948931, 1322051793364672513, 'swan-cloud-system$authority_menu_flag$menu_manager');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948932, 1322051793364672513, 'swan-cloud-system$authority_menu_flag$role_manager');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948933, 1322051793364672513, 'swan-cloud-system$authority_menu_flag$authority_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948934, 1322051793364672513, 'swan-cloud-system$authority_menu_flag$res_maintain');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948935, 1322051793364672513, 'swan-cloud-system$ent_duty$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948936, 1322051793364672513, 'swan-cloud-system$ent_duty$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948937, 1322051793364672513, 'swan-cloud-system$ent_duty$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948938, 1322051793364672513, 'swan-cloud-system$ent_duty$change_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948939, 1322051793364672513, 'swan-cloud-system$ent_duty$query_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948940, 1322051793364672513, 'swan-cloud-system$ent_duty$detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948941, 1322051793364672513, 'swan-cloud-system$ent_duty$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948942, 1322051793364672513, 'swan-cloud-system$ent_user_account$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948943, 1322051793364672513, 'swan-cloud-system$ent_user_account$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948944, 1322051793364672513, 'swan-cloud-system$ent_user_account$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948945, 1322051793364672513, 'swan-cloud-system$ent_user_account$query_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948946, 1322051793364672513, 'swan-cloud-system$ent_user_account$query_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948947, 1322051793364672513, 'swan-cloud-system$ent_user_account$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948948, 1322051793364672513, 'swan-cloud-system$ent_user_dept$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948949, 1322051793364672513, 'swan-cloud-system$ent_user_dept$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948950, 1322051793364672513, 'swan-cloud-system$ent_user_dept$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948951, 1322051793364672513, 'swan-cloud-system$ent_user_dept$query_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948952, 1322051793364672513, 'swan-cloud-system$ent_user_dept$query_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948953, 1322051793364672513, 'swan-cloud-system$ent_user_dept$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948954, 1322051793364672513, 'swan-cloud-system$file$upload');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948955, 1322051793364672513, 'swan-cloud-system$file$file_access');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948956, 1322051793364672513, 'swan-cloud-system$file$preview');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948957, 1322051793364672513, 'swan-cloud-system$permission$get_permission_list4_level');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948958, 1322051793364672513, 'swan-cloud-system$permission$get_permission_page_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948959, 1322051793364672513, 'swan-cloud-system$permission$add_permission');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948960, 1322051793364672513, 'swan-cloud-system$permission$set_permission_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948961, 1322051793364672513, 'swan-cloud-system$permission$remove_permission');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948962, 1322051793364672513, 'swan-cloud-system$permission$permission_bind_resource');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948963, 1322051793364672513, 'swan-cloud-system$permission$get_app_button_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948964, 1322051793364672513, 'swan-cloud-system$permission$get_permission_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948965, 1322051793364672513, 'swan-cloud-system$permission$get_permission_resource_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948966, 1322051793364672513, 'swan-cloud-system$permission$get_resource_list4_permission');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948967, 1322051793364672513, 'swan-cloud-system$permission$get_permission_resource_list_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948968, 1322051793364672513, 'swan-cloud-system$permission$cancel_permission_bind_resource');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948969, 1322051793364672513, 'swan-cloud-system$res_cache$edit_res_cache');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948970, 1322051793364672513, 'swan-cloud-system$res_cache$remove_res_cache');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948971, 1322051793364672513, 'swan-cloud-system$res_cache$add_res_cache');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948972, 1322051793364672513, 'swan-cloud-system$res_cache$get_http_request_select');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948973, 1322051793364672513, 'swan-cloud-system$res_cache$get_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443181948974, 1322051793364672513, 'swan-cloud-system$res_cache$get_res_module_select');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143233, 1322051793364672513, 'swan-cloud-system$res_cache$get_res_cache_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143234, 1322051793364672513, 'swan-cloud-system$ent_user$save_roles');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143235, 1322051793364672513, 'swan-cloud-system$ent_user$save_current_user');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143236, 1322051793364672513, 'swan-cloud-system$ent_user$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143237, 1322051793364672513, 'swan-cloud-system$ent_user$update_password');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143238, 1322051793364672513, 'swan-cloud-system$ent_user$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143239, 1322051793364672513, 'swan-cloud-system$ent_user$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143240, 1322051793364672513, 'swan-cloud-system$ent_user$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143241, 1322051793364672513, 'swan-cloud-system$ent_user$change_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143242, 1322051793364672513, 'swan-cloud-system$ent_user$get_company_select');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143243, 1322051793364672513, 'swan-cloud-system$ent_user$get_current_user');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143244, 1322051793364672513, 'swan-cloud-system$ent_user$get_roles');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143245, 1322051793364672513, 'swan-cloud-system$ent_user$query_info_by_dict_type');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143246, 1322051793364672513, 'swan-cloud-system$ent_user$get_duty_select');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143247, 1322051793364672513, 'swan-cloud-system$ent_user$get_dept_select');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143248, 1322051793364672513, 'swan-cloud-system$ent_user$detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143249, 1322051793364672513, 'swan-cloud-system$ent_user$reset_password');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143250, 1322051793364672513, 'swan-cloud-system$resource$get_resource_select_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143251, 1322051793364672513, 'swan-cloud-system$resource$resource_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143252, 1322051793364672513, 'swan-cloud-system$dict_type$check_code');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143253, 1322051793364672513, 'swan-cloud-system$dict_type$update_dict_type');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143254, 1322051793364672513, 'swan-cloud-system$dict_type$update_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143255, 1322051793364672513, 'swan-cloud-system$dict_type$delete_dict_type');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143256, 1322051793364672513, 'swan-cloud-system$dict_type$add_dict_type');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143257, 1322051793364672513, 'swan-cloud-system$dict_type$get_dict_type_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143258, 1322051793364672513, 'swan-cloud-system$ent_menu_flag$personal');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143259, 1322051793364672513, 'swan-cloud-system$ent_menu_flag$system');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143260, 1322051793364672513, 'swan-cloud-system$ent_menu_flag$duty');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143261, 1322051793364672513, 'swan-cloud-system$ent_menu_flag$dept');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143262, 1322051793364672513, 'swan-cloud-system$role$assign_permission');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143263, 1322051793364672513, 'swan-cloud-system$role$delete_role');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143264, 1322051793364672513, 'swan-cloud-system$role$update_role');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143265, 1322051793364672513, 'swan-cloud-system$role$select_role_by_account_id');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143266, 1322051793364672513, 'swan-cloud-system$role$find_role_all_permissions');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143267, 1322051793364672513, 'swan-cloud-system$role$find_permissions');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143268, 1322051793364672513, 'swan-cloud-system$role$validate_name');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143269, 1322051793364672513, 'swan-cloud-system$role$validate_code');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143270, 1322051793364672513, 'swan-cloud-system$role$add_role');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143271, 1322051793364672513, 'swan-cloud-system$role$find_all_role');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143272, 1322051793364672513, 'swan-cloud-system$role$get_all_res_permissions');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143273, 1322051793364672513, 'swan-cloud-system$role$get_all_res_permission_urls');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143274, 1322051793364672513, 'swan-cloud-system$role$find_role_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143275, 1322051793364672513, 'swan-cloud-system$role$find_role_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143276, 1322051793364672513, 'swan-cloud-system$role$set_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143277, 1322051793364672513, 'swan-cloud-system$sys_button$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143278, 1322051793364672513, 'swan-cloud-system$sys_button$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143279, 1322051793364672513, 'swan-cloud-system$sys_button$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143280, 1322051793364672513, 'swan-cloud-system$sys_button$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143281, 1322051793364672513, 'swan-cloud-system$sys_button$change_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143282, 1322051793364672513, 'swan-cloud-system$sys_button$get_button_permission');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143283, 1322051793364672513, 'swan-cloud-system$sys_button$get_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143284, 1322051793364672513, 'swan-cloud-system$menu$get_left_menu_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143285, 1322051793364672513, 'swan-cloud-system$menu$get_select_menu_tree_list');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143286, 1322051793364672513, 'swan-cloud-system$menu$list_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143287, 1322051793364672513, 'swan-cloud-system$menu$get_menu_detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143288, 1322051793364672513, 'swan-cloud-system$ent_dept$update');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143289, 1322051793364672513, 'swan-cloud-system$ent_dept$query_list_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143290, 1322051793364672513, 'swan-cloud-system$ent_dept$delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143291, 1322051793364672513, 'swan-cloud-system$ent_dept$add');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143292, 1322051793364672513, 'swan-cloud-system$ent_dept$change_status');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143293, 1322051793364672513, 'swan-cloud-system$ent_dept$query_dept_tree');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143294, 1322051793364672513, 'swan-cloud-system$ent_dept$detail');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143295, 1322051793364672513, 'swan-cloud-system$log_menu_flag$biz_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143296, 1322051793364672513, 'swan-cloud-system$sys_log$op_log_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143297, 1322051793364672513, 'swan-cloud-system$sys_log$op_log_delete');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143298, 1322051793364672513, 'swan-cloud-system$log_menu_flag$logs_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143299, 1322051793364672513, 'swan-cloud-system$log_menu_flag$login_menu');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143300, 1322051793364672513, 'swan-cloud-system$sys_log$login_log_page');
INSERT INTO `swan_sys_permission_resource` (`permission_resource_id`, `permission_id`, `resource_id`) VALUES (1328516443186143301, 1322051793364672513, 'swan-cloud-system$sys_log$detail');
COMMIT;

-- ----------------------------
-- Table structure for swan_sys_resource
-- ----------------------------
DROP TABLE IF EXISTS `swan_sys_resource`;
CREATE TABLE `swan_sys_resource`  (
  `resource_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '资源id',
  `app_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用编码',
  `project_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目编码',
  `class_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类名称',
  `method_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '方法名称',
  `modular_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源模块编码',
  `modular_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源模块名称',
  `code` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '资源编码',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源名称',
  `ip_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源初始化的服务器ip地址',
  `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源url',
  `http_method` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'http请求方法',
  `menu_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否是方法(Y:页面 N:api)',
  `required_login_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否需要登录(Y:是 N:否)',
  `required_permission_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否需要鉴权标识(Y:是 N:否)',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`resource_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '资源表';

-- ----------------------------
-- Records of swan_sys_resource
-- ----------------------------
BEGIN;
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$authority_menu_flag$authority_menu', 'swan-cloud-system', 'swan-cloud-system', 'AuthorityMenuFlagController', 'authorityMenu', 'AuthorityMenuFlag', '资源权限菜单', 'swan-cloud-system$authority_menu_flag$authority_menu', '资源权限菜单', '192.168.9.249', '/swan-cloud-system/authorityMenu/authorityMenu', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$authority_menu_flag$menu_manager', 'swan-cloud-system', 'swan-cloud-system', 'AuthorityMenuFlagController', 'menuManager', 'AuthorityMenuFlag', '资源权限菜单', 'swan-cloud-system$authority_menu_flag$menu_manager', '菜单管理', '192.168.9.249', '/swan-cloud-system/authorityMenu/menuManager', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$authority_menu_flag$permission_manager', 'swan-cloud-system', 'swan-cloud-system', 'AuthorityMenuFlagController', 'permissionManager', 'AuthorityMenuFlag', '资源权限菜单', 'swan-cloud-system$authority_menu_flag$permission_manager', '权限管理', '192.168.9.249', '/swan-cloud-system/authorityMenu/permissionManager', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$authority_menu_flag$res_maintain', 'swan-cloud-system', 'swan-cloud-system', 'AuthorityMenuFlagController', 'resMaintain', 'AuthorityMenuFlag', '资源权限菜单', 'swan-cloud-system$authority_menu_flag$res_maintain', '资源维护', '192.168.9.249', '/swan-cloud-system/authorityMenu/resMaintain', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$authority_menu_flag$role_manager', 'swan-cloud-system', 'swan-cloud-system', 'AuthorityMenuFlagController', 'roleManager', 'AuthorityMenuFlag', '资源权限菜单', 'swan-cloud-system$authority_menu_flag$role_manager', '角色管理', '192.168.9.249', '/swan-cloud-system/authorityMenu/roleManager', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dash_board$get_biz_statistics', 'swan-cloud-system', 'swan-cloud-system', 'DashBoardController', 'getBizStatistics', 'DashBoard', '首页DashBoard接口', 'swan-cloud-system$dash_board$get_biz_statistics', '获取DashBoard业务统计数据', '192.168.9.249', '/swan-cloud-system/dashboard/getBizStatistics', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dash_board$get_modules_statistics', 'swan-cloud-system', 'swan-cloud-system', 'DashBoardController', 'getModulesStatistics', 'DashBoard', '首页DashBoard接口', 'swan-cloud-system$dash_board$get_modules_statistics', '获取DashBoard模块统计数据', '192.168.9.249', '/swan-cloud-system/dashboard/getModulesStatistics', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict$add_dict_type', 'swan-cloud-system', 'swan-cloud-system', 'DictController', 'addDictType', 'Dict', '字典管理', 'swan-cloud-system$dict$add_dict_type', '添加字典', '192.168.9.249', '/swan-cloud-system/dict/addDict', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict$check_code', 'swan-cloud-system', 'swan-cloud-system', 'DictController', 'checkCode', 'Dict', '字典管理', 'swan-cloud-system$dict$check_code', 'code校验', '192.168.9.249', '/swan-cloud-system/dict/checkCode', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict$delete_dict', 'swan-cloud-system', 'swan-cloud-system', 'DictController', 'deleteDict', 'Dict', '字典管理', 'swan-cloud-system$dict$delete_dict', '删除字典', '192.168.9.249', '/swan-cloud-system/dict/deleteDict', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict$get_dict_list', 'swan-cloud-system', 'swan-cloud-system', 'DictController', 'getDictList', 'Dict', '字典管理', 'swan-cloud-system$dict$get_dict_list', '获取字典列表', '192.168.9.249', '/swan-cloud-system/dict/getDictList', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict$get_dict_list_by_type_code', 'swan-cloud-system', 'swan-cloud-system', 'DictController', 'getDictListByTypeCode', 'Dict', '字典管理', 'swan-cloud-system$dict$get_dict_list_by_type_code', '根据字典类型code获取所有字典', '192.168.9.249', '/swan-cloud-system/dict/getDictListByTypeCode', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict$get_dict_page', 'swan-cloud-system', 'swan-cloud-system', 'DictController', 'getDictPage', 'Dict', '字典管理', 'swan-cloud-system$dict$get_dict_page', '获取字典列表', '192.168.9.249', '/swan-cloud-system/dict/getDictPage', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict$get_dict_tree_list', 'swan-cloud-system', 'swan-cloud-system', 'DictController', 'getDictTreeList', 'Dict', '字典管理', 'swan-cloud-system$dict$get_dict_tree_list', '获取树形字典列表', '192.168.9.249', '/swan-cloud-system/dict/getDictTreeList', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict$get_list_by_type_code_and_PC_ode', 'swan-cloud-system', 'swan-cloud-system', 'DictController', 'getListByTypeCodeAndPCode', 'Dict', '字典管理', 'swan-cloud-system$dict$get_list_by_type_code_and_PC_ode', '根据字典类型code和父编码获取下级字典', '192.168.9.249', '/swan-cloud-system/dict/getListByTypeCodeAndPCode', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict$update_dict', 'swan-cloud-system', 'swan-cloud-system', 'DictController', 'updateDict', 'Dict', '字典管理', 'swan-cloud-system$dict$update_dict', '修改字典', '192.168.9.249', '/swan-cloud-system/dict/updateDict', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict$update_dict_status', 'swan-cloud-system', 'swan-cloud-system', 'DictController', 'updateDictStatus', 'Dict', '字典管理', 'swan-cloud-system$dict$update_dict_status', '更新字典状态', '192.168.9.249', '/swan-cloud-system/dict/updateDictStatus', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict_type$add_dict_type', 'swan-cloud-system', 'swan-cloud-system', 'DictTypeController', 'addDictType', 'DictType', '字典类型管理', 'swan-cloud-system$dict_type$add_dict_type', '添加字典类型', '192.168.9.249', '/swan-cloud-system/dictType/addDictType', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict_type$check_code', 'swan-cloud-system', 'swan-cloud-system', 'DictTypeController', 'checkCode', 'DictType', '字典类型管理', 'swan-cloud-system$dict_type$check_code', 'code校验', '192.168.9.249', '/swan-cloud-system/dictType/checkCode', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict_type$delete_dict_type', 'swan-cloud-system', 'swan-cloud-system', 'DictTypeController', 'deleteDictType', 'DictType', '字典类型管理', 'swan-cloud-system$dict_type$delete_dict_type', '删除字典类型', '192.168.9.249', '/swan-cloud-system/dictType/deleteDictType', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict_type$get_dict_type_list', 'swan-cloud-system', 'swan-cloud-system', 'DictTypeController', 'getDictTypeList', 'DictType', '字典类型管理', 'swan-cloud-system$dict_type$get_dict_type_list', '获取字典类型列表', '192.168.9.249', '/swan-cloud-system/dictType/getDictTypeList', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict_type$update_dict_type', 'swan-cloud-system', 'swan-cloud-system', 'DictTypeController', 'updateDictType', 'DictType', '字典类型管理', 'swan-cloud-system$dict_type$update_dict_type', '修改字典类型', '192.168.9.249', '/swan-cloud-system/dictType/updateDictType', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$dict_type$update_status', 'swan-cloud-system', 'swan-cloud-system', 'DictTypeController', 'updateStatus', 'DictType', '字典类型管理', 'swan-cloud-system$dict_type$update_status', '修改字典类型状态', '192.168.9.249', '/swan-cloud-system/dictType/updateStatus', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_dept$add', 'swan-cloud-system', 'swan-cloud-system', 'EntDeptController', 'add', 'EntDept', '部门表管理', 'swan-cloud-system$ent_dept$add', '添加', '192.168.9.249', '/swan-cloud-system/entDept/add', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_dept$change_status', 'swan-cloud-system', 'swan-cloud-system', 'EntDeptController', 'changeStatus', 'EntDept', '部门表管理', 'swan-cloud-system$ent_dept$change_status', '禁用启用', '192.168.9.249', '/swan-cloud-system/entDept/changeStatus', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_dept$delete', 'swan-cloud-system', 'swan-cloud-system', 'EntDeptController', 'delete', 'EntDept', '部门表管理', 'swan-cloud-system$ent_dept$delete', '删除', '192.168.9.249', '/swan-cloud-system/entDept/delete', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_dept$detail', 'swan-cloud-system', 'swan-cloud-system', 'EntDeptController', 'detail', 'EntDept', '部门表管理', 'swan-cloud-system$ent_dept$detail', '详情', '192.168.9.249', '/swan-cloud-system/entDept/detail', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_dept$query_dept_tree', 'swan-cloud-system', 'swan-cloud-system', 'EntDeptController', 'queryDeptTree', 'EntDept', '部门表管理', 'swan-cloud-system$ent_dept$query_dept_tree', '获取部门树列表', '192.168.9.249', '/swan-cloud-system/entDept/queryDeptTree', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_dept$query_list_page', 'swan-cloud-system', 'swan-cloud-system', 'EntDeptController', 'queryListPage', 'EntDept', '部门表管理', 'swan-cloud-system$ent_dept$query_list_page', '分页查询列表', '192.168.9.249', '/swan-cloud-system/entDept/queryListPage', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_dept$update', 'swan-cloud-system', 'swan-cloud-system', 'EntDeptController', 'update', 'EntDept', '部门表管理', 'swan-cloud-system$ent_dept$update', '修改', '192.168.9.249', '/swan-cloud-system/entDept/update', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_duty$add', 'swan-cloud-system', 'swan-cloud-system', 'EntDutyController', 'add', 'EntDuty', '职务管理管理', 'swan-cloud-system$ent_duty$add', '添加', '192.168.9.249', '/swan-cloud-system/entDuty/add', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_duty$change_status', 'swan-cloud-system', 'swan-cloud-system', 'EntDutyController', 'changeStatus', 'EntDuty', '职务管理管理', 'swan-cloud-system$ent_duty$change_status', '禁用启用', '192.168.9.249', '/swan-cloud-system/entDuty/changeStatus', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_duty$delete', 'swan-cloud-system', 'swan-cloud-system', 'EntDutyController', 'delete', 'EntDuty', '职务管理管理', 'swan-cloud-system$ent_duty$delete', '删除', '192.168.9.249', '/swan-cloud-system/entDuty/delete', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_duty$detail', 'swan-cloud-system', 'swan-cloud-system', 'EntDutyController', 'detail', 'EntDuty', '职务管理管理', 'swan-cloud-system$ent_duty$detail', '详情', '192.168.9.249', '/swan-cloud-system/entDuty/detail', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_duty$query_list', 'swan-cloud-system', 'swan-cloud-system', 'EntDutyController', 'queryList', 'EntDuty', '职务管理管理', 'swan-cloud-system$ent_duty$query_list', '职务不分页列表', '192.168.9.249', '/swan-cloud-system/entDuty/queryList', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_duty$query_list_page', 'swan-cloud-system', 'swan-cloud-system', 'EntDutyController', 'queryListPage', 'EntDuty', '职务管理管理', 'swan-cloud-system$ent_duty$query_list_page', '分页查询列表', '192.168.9.249', '/swan-cloud-system/entDuty/queryListPage', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_duty$update', 'swan-cloud-system', 'swan-cloud-system', 'EntDutyController', 'update', 'EntDuty', '职务管理管理', 'swan-cloud-system$ent_duty$update', '修改', '192.168.9.249', '/swan-cloud-system/entDuty/update', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:05', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_menu_flag$dept', 'swan-cloud-system', 'swan-cloud-system', 'EntMenuFlagController', 'dept', 'EntMenuFlag', '组织架构', 'swan-cloud-system$ent_menu_flag$dept', '部门管理', '192.168.9.249', '/swan-cloud-system/entMenu/dept', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_menu_flag$duty', 'swan-cloud-system', 'swan-cloud-system', 'EntMenuFlagController', 'duty', 'EntMenuFlag', '组织架构', 'swan-cloud-system$ent_menu_flag$duty', '职位管理', '192.168.9.249', '/swan-cloud-system/entMenu/duty', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_menu_flag$personal', 'swan-cloud-system', 'swan-cloud-system', 'EntMenuFlagController', 'personal', 'EntMenuFlag', '组织架构', 'swan-cloud-system$ent_menu_flag$personal', '人员管理', '192.168.9.249', '/swan-cloud-system/entMenu/personal', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_menu_flag$system', 'swan-cloud-system', 'swan-cloud-system', 'EntMenuFlagController', 'system', 'EntMenuFlag', '组织架构', 'swan-cloud-system$ent_menu_flag$system', '组织架构菜单', '192.168.9.249', '/swan-cloud-system/entMenu/enterprise', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$add', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'add', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$add', '添加', '192.168.9.249', '/swan-cloud-system/entUser/add', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$change_status', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'changeStatus', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$change_status', '禁用启用', '192.168.9.249', '/swan-cloud-system/entUser/changeStatus', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$delete', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'delete', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$delete', '删除', '192.168.9.249', '/swan-cloud-system/entUser/delete', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$detail', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'detail', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$detail', '详情', '192.168.9.249', '/swan-cloud-system/entUser/detail', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$get_company_select', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'getCompanySelect', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$get_company_select', '获取公司下拉列表', '192.168.9.249', '/swan-cloud-system/entUser/getCompanySelect', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$get_current_user', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'getCurrentUser', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$get_current_user', '获取当前登录人信息', '192.168.9.249', '/swan-cloud-system/entUser/getCurrentUser', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$get_dept_select', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'getDeptSelect', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$get_dept_select', '获取部门下拉列表', '192.168.9.249', '/swan-cloud-system/entUser/getDeptSelect', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$get_duty_select', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'getDutySelect', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$get_duty_select', '获取职务下拉列表', '192.168.9.249', '/swan-cloud-system/entUser/getDutySelect', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$get_roles', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'getRoles', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$get_roles', '获取所有的角色信息', '192.168.9.249', '/swan-cloud-system/entUser/getRoles', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$query_info_by_dict_type', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'queryInfoByDictType', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$query_info_by_dict_type', '获取用户在字典表对应的信息', '192.168.9.249', '/swan-cloud-system/entUser/queryInfoByDictType', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$query_list_page', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'queryListPage', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$query_list_page', '分页查询列表', '192.168.9.249', '/swan-cloud-system/entUser/queryListPage', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$reset_password', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'resetPassword', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$reset_password', '重置密码', '192.168.9.249', '/swan-cloud-system/entUser/resetPassword', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$save_current_user', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'saveCurrentUser', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$save_current_user', '保存当前登录人的信息', '192.168.9.249', '/swan-cloud-system/entUser/saveCurrentUser', 'POST', 'N', 'Y', 'N', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$save_roles', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'saveRoles', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$save_roles', '保存人员配置好的角色', '192.168.9.249', '/swan-cloud-system/entUser/saveRoles', 'POST', 'N', 'Y', 'N', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$update', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'update', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$update', '修改', '192.168.9.249', '/swan-cloud-system/entUser/update', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user$update_password', 'swan-cloud-system', 'swan-cloud-system', 'EntUserController', 'updatePassword', 'EntUser', '用户信息管理', 'swan-cloud-system$ent_user$update_password', '修改密码', '192.168.9.249', '/swan-cloud-system/entUser/updatePassword', 'POST', 'N', 'Y', 'N', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user_account$add', 'swan-cloud-system', 'swan-cloud-system', 'EntUserAccountController', 'add', 'EntUserAccount', '登录账号管理', 'swan-cloud-system$ent_user_account$add', '添加', '192.168.9.249', '/swan-cloud-system/entUserAccount/add', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user_account$delete', 'swan-cloud-system', 'swan-cloud-system', 'EntUserAccountController', 'delete', 'EntUserAccount', '登录账号管理', 'swan-cloud-system$ent_user_account$delete', '删除', '192.168.9.249', '/swan-cloud-system/entUserAccount/delete', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user_account$query_detail', 'swan-cloud-system', 'swan-cloud-system', 'EntUserAccountController', 'queryDetail', 'EntUserAccount', '登录账号管理', 'swan-cloud-system$ent_user_account$query_detail', '查询详情', '192.168.9.249', '/swan-cloud-system/entUserAccount/queryDetail', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user_account$query_list', 'swan-cloud-system', 'swan-cloud-system', 'EntUserAccountController', 'queryList', 'EntUserAccount', '登录账号管理', 'swan-cloud-system$ent_user_account$query_list', '查询列表', '192.168.9.249', '/swan-cloud-system/entUserAccount/queryList', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user_account$query_list_page', 'swan-cloud-system', 'swan-cloud-system', 'EntUserAccountController', 'queryListPage', 'EntUserAccount', '登录账号管理', 'swan-cloud-system$ent_user_account$query_list_page', '分页查询列表', '192.168.9.249', '/swan-cloud-system/entUserAccount/queryListPage', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user_account$update', 'swan-cloud-system', 'swan-cloud-system', 'EntUserAccountController', 'update', 'EntUserAccount', '登录账号管理', 'swan-cloud-system$ent_user_account$update', '修改', '192.168.9.249', '/swan-cloud-system/entUserAccount/update', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:08', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user_dept$add', 'swan-cloud-system', 'swan-cloud-system', 'EntUserDeptController', 'add', 'EntUserDept', '用户部门关联表管理', 'swan-cloud-system$ent_user_dept$add', '添加', '192.168.9.249', '/swan-cloud-system/entUserDept/add', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:06', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user_dept$delete', 'swan-cloud-system', 'swan-cloud-system', 'EntUserDeptController', 'delete', 'EntUserDept', '用户部门关联表管理', 'swan-cloud-system$ent_user_dept$delete', '删除', '192.168.9.249', '/swan-cloud-system/entUserDept/delete', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:06', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user_dept$query_detail', 'swan-cloud-system', 'swan-cloud-system', 'EntUserDeptController', 'queryDetail', 'EntUserDept', '用户部门关联表管理', 'swan-cloud-system$ent_user_dept$query_detail', '查询详情', '192.168.9.249', '/swan-cloud-system/entUserDept/queryDetail', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:06', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user_dept$query_list', 'swan-cloud-system', 'swan-cloud-system', 'EntUserDeptController', 'queryList', 'EntUserDept', '用户部门关联表管理', 'swan-cloud-system$ent_user_dept$query_list', '查询列表', '192.168.9.249', '/swan-cloud-system/entUserDept/queryList', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:06', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user_dept$query_list_page', 'swan-cloud-system', 'swan-cloud-system', 'EntUserDeptController', 'queryListPage', 'EntUserDept', '用户部门关联表管理', 'swan-cloud-system$ent_user_dept$query_list_page', '分页查询列表', '192.168.9.249', '/swan-cloud-system/entUserDept/queryListPage', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:06', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$ent_user_dept$update', 'swan-cloud-system', 'swan-cloud-system', 'EntUserDeptController', 'update', 'EntUserDept', '用户部门关联表管理', 'swan-cloud-system$ent_user_dept$update', '修改', '192.168.9.249', '/swan-cloud-system/entUserDept/update', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:06', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$file$file_access', 'swan-cloud-system', 'swan-cloud-system', 'FileController', 'fileAccess', 'File', '文件系统', 'swan-cloud-system$file$file_access', '文件下载', '192.168.9.249', '/swan-cloud-system/file/download', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:06', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$file$preview', 'swan-cloud-system', 'swan-cloud-system', 'FileController', 'preview', 'File', '文件系统', 'swan-cloud-system$file$preview', '文件预览', '192.168.9.249', '/swan-cloud-system/file/preview', 'GET', 'N', 'N', 'N', -100, '2020-11-25 14:00:06', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$file$upload', 'swan-cloud-system', 'swan-cloud-system', 'FileController', 'upload', 'File', '文件系统', 'swan-cloud-system$file$upload', '文件上传', '192.168.9.249', '/swan-cloud-system/file/upload', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:06', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$log_menu_flag$biz_menu', 'swan-cloud-system', 'swan-cloud-system', 'LogMenuFlagController', 'bizMenu', 'LogMenuFlag', '日志管理', 'swan-cloud-system$log_menu_flag$biz_menu', '业务日志', '192.168.9.249', '/swan-cloud-system/logMenu/bizMenu', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$log_menu_flag$login_menu', 'swan-cloud-system', 'swan-cloud-system', 'LogMenuFlagController', 'loginMenu', 'LogMenuFlag', '日志管理', 'swan-cloud-system$log_menu_flag$login_menu', '登录日志', '192.168.9.249', '/swan-cloud-system/logMenu/loginMenu', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$log_menu_flag$logs_menu', 'swan-cloud-system', 'swan-cloud-system', 'LogMenuFlagController', 'logsMenu', 'LogMenuFlag', '日志管理', 'swan-cloud-system$log_menu_flag$logs_menu', '日志管理菜单（一级）', '192.168.9.249', '/swan-cloud-system/logMenu/logsMenu', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$menu$add_menu', 'swan-cloud-system', 'swan-cloud-system', 'MenuController', 'addMenu', 'Menu', '菜单管理接口', 'swan-cloud-system$menu$add_menu', '新增菜单', '192.168.9.249', '/swan-cloud-system/menu/add', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$menu$delete_menu', 'swan-cloud-system', 'swan-cloud-system', 'MenuController', 'deleteMenu', 'Menu', '菜单管理接口', 'swan-cloud-system$menu$delete_menu', '删除菜单', '192.168.9.249', '/swan-cloud-system/menu/delete', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$menu$edit_menu', 'swan-cloud-system', 'swan-cloud-system', 'MenuController', 'editMenu', 'Menu', '菜单管理接口', 'swan-cloud-system$menu$edit_menu', '编辑菜单', '192.168.9.249', '/swan-cloud-system/menu/update', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$menu$enable_menu', 'swan-cloud-system', 'swan-cloud-system', 'MenuController', 'enableMenu', 'Menu', '菜单管理接口', 'swan-cloud-system$menu$enable_menu', '启用禁用菜单', '192.168.9.249', '/swan-cloud-system/menu/changeStatus', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$menu$get_left_menu_list', 'swan-cloud-system', 'swan-cloud-system', 'MenuController', 'getLeftMenuList', 'Menu', '菜单管理接口', 'swan-cloud-system$menu$get_left_menu_list', '获取左侧菜单列表', '192.168.9.249', '/swan-cloud-system/menu/getLeftMenuList', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$menu$get_menu_detail', 'swan-cloud-system', 'swan-cloud-system', 'MenuController', 'getMenuDetail', 'Menu', '菜单管理接口', 'swan-cloud-system$menu$get_menu_detail', '获取菜单详情', '192.168.9.249', '/swan-cloud-system/menu/getMenuDetail', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$menu$get_select_menu_tree_list', 'swan-cloud-system', 'swan-cloud-system', 'MenuController', 'getSelectMenuTreeList', 'Menu', '菜单管理接口', 'swan-cloud-system$menu$get_select_menu_tree_list', '获取父级菜单列表', '192.168.9.249', '/swan-cloud-system/menu/getSelectMenuTreeList', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$menu$list_menu', 'swan-cloud-system', 'swan-cloud-system', 'MenuController', 'listMenu', 'Menu', '菜单管理接口', 'swan-cloud-system$menu$list_menu', '获取菜单列表', '192.168.9.249', '/swan-cloud-system/menu/list', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$permission$add_permission', 'swan-cloud-system', 'swan-cloud-system', 'PermissionController', 'addPermission', 'Permission', '权限控制', 'swan-cloud-system$permission$add_permission', '新增权限', '192.168.9.249', '/swan-cloud-system/permission/add', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$permission$cancel_permission_bind_resource', 'swan-cloud-system', 'swan-cloud-system', 'PermissionController', 'cancelPermissionBindResource', 'Permission', '权限控制', 'swan-cloud-system$permission$cancel_permission_bind_resource', '解除权限绑定资源', '192.168.9.249', '/swan-cloud-system/permission/cancelPermissionBindResource', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$permission$get_app_button_status', 'swan-cloud-system', 'swan-cloud-system', 'PermissionController', 'getAppButtonStatus', 'Permission', '权限控制', 'swan-cloud-system$permission$get_app_button_status', '获取应用按钮状态', '192.168.9.249', '/swan-cloud-system/permission/getAppButtonStatus', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$permission$get_permission_list', 'swan-cloud-system', 'swan-cloud-system', 'PermissionController', 'getPermissionList', 'Permission', '权限控制', 'swan-cloud-system$permission$get_permission_list', '获取所有权限列表', '192.168.9.249', '/swan-cloud-system/permission/getPermissionList', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$permission$get_permission_list4_level', 'swan-cloud-system', 'swan-cloud-system', 'PermissionController', 'getPermissionList4Level', 'Permission', '权限控制', 'swan-cloud-system$permission$get_permission_list4_level', '分级加载权限', '192.168.9.249', '/swan-cloud-system/permission/getPermissionList4Level', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$permission$get_permission_page_list', 'swan-cloud-system', 'swan-cloud-system', 'PermissionController', 'getPermissionPageList', 'Permission', '权限控制', 'swan-cloud-system$permission$get_permission_page_list', '分页获取权限列表', '192.168.9.249', '/swan-cloud-system/permission/getPermissionPageList', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$permission$get_permission_resource_list', 'swan-cloud-system', 'swan-cloud-system', 'PermissionController', 'getPermissionResourceList', 'Permission', '权限控制', 'swan-cloud-system$permission$get_permission_resource_list', '获取权限绑定的资源', '192.168.9.249', '/swan-cloud-system/permission/getPermissionResourceList', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$permission$get_permission_resource_list_detail', 'swan-cloud-system', 'swan-cloud-system', 'PermissionController', 'getPermissionResourceListDetail', 'Permission', '权限控制', 'swan-cloud-system$permission$get_permission_resource_list_detail', '获取权限资源的关系', '192.168.9.249', '/swan-cloud-system/permission/getPermissionResourceRelation', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$permission$get_resource_list4_permission', 'swan-cloud-system', 'swan-cloud-system', 'PermissionController', 'getResourceList4Permission', 'Permission', '权限控制', 'swan-cloud-system$permission$get_resource_list4_permission', '获取权限资源列表', '192.168.9.249', '/swan-cloud-system/permission/getResourceList4Permission', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$permission$permission_bind_resource', 'swan-cloud-system', 'swan-cloud-system', 'PermissionController', 'permissionBindResource', 'Permission', '权限控制', 'swan-cloud-system$permission$permission_bind_resource', '权限绑定资源', '192.168.9.249', '/swan-cloud-system/permission/permissionBindResource', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$permission$remove_permission', 'swan-cloud-system', 'swan-cloud-system', 'PermissionController', 'removePermission', 'Permission', '权限控制', 'swan-cloud-system$permission$remove_permission', '权限删除', '192.168.9.249', '/swan-cloud-system/permission/removePermission', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$permission$set_permission_status', 'swan-cloud-system', 'swan-cloud-system', 'PermissionController', 'setPermissionStatus', 'Permission', '权限控制', 'swan-cloud-system$permission$set_permission_status', '更改权限状态', '192.168.9.249', '/swan-cloud-system/permission/setPermissionStatus', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$resource$get_resource_select_list', 'swan-cloud-system', 'swan-cloud-system', 'ResourceController', 'getResourceSelectList', 'Resource', '资源管理', 'swan-cloud-system$resource$get_resource_select_list', '获取资源下拉列表', '192.168.9.249', '/swan-cloud-system/resource/getResourceSelectList', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$resource$resource_list', 'swan-cloud-system', 'swan-cloud-system', 'ResourceController', 'resourceList', 'Resource', '资源管理', 'swan-cloud-system$resource$resource_list', '获取资源列表', '192.168.9.249', '/swan-cloud-system/resource/list', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$res_cache$add_res_cache', 'swan-cloud-system', 'swan-cloud-system', 'ResCacheController', 'addResCache', 'ResCache', '资源缓存维护管理', 'swan-cloud-system$res_cache$add_res_cache', '新增资源缓存', '192.168.9.249', '/swan-cloud-system/resCacheManager/addResCache', 'POST', 'N', 'Y', 'N', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$res_cache$edit_res_cache', 'swan-cloud-system', 'swan-cloud-system', 'ResCacheController', 'editResCache', 'ResCache', '资源缓存维护管理', 'swan-cloud-system$res_cache$edit_res_cache', '修改资源缓存', '192.168.9.249', '/swan-cloud-system/resCacheManager/editResCache', 'POST', 'N', 'Y', 'N', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$res_cache$get_detail', 'swan-cloud-system', 'swan-cloud-system', 'ResCacheController', 'getDetail', 'ResCache', '资源缓存维护管理', 'swan-cloud-system$res_cache$get_detail', '获取缓存资源的详情', '192.168.9.249', '/swan-cloud-system/resCacheManager/getDetail', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$res_cache$get_http_request_select', 'swan-cloud-system', 'swan-cloud-system', 'ResCacheController', 'getHttpRequestSelect', 'ResCache', '资源缓存维护管理', 'swan-cloud-system$res_cache$get_http_request_select', '获取http请求下拉列表', '192.168.9.249', '/swan-cloud-system/resCacheManager/getHttpRequestSelect', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$res_cache$get_res_cache_list', 'swan-cloud-system', 'swan-cloud-system', 'ResCacheController', 'getResCacheList', 'ResCache', '资源缓存维护管理', 'swan-cloud-system$res_cache$get_res_cache_list', '获取资源缓存分页', '192.168.9.249', '/swan-cloud-system/resCacheManager/getResCacheList', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$res_cache$get_res_module_select', 'swan-cloud-system', 'swan-cloud-system', 'ResCacheController', 'getResModuleSelect', 'ResCache', '资源缓存维护管理', 'swan-cloud-system$res_cache$get_res_module_select', '获取资源所属模块下拉列表', '192.168.9.249', '/swan-cloud-system/resCacheManager/getResModuleSelect', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$res_cache$remove_res_cache', 'swan-cloud-system', 'swan-cloud-system', 'ResCacheController', 'removeResCache', 'ResCache', '资源缓存维护管理', 'swan-cloud-system$res_cache$remove_res_cache', '删除资源缓存', '192.168.9.249', '/swan-cloud-system/resCacheManager/removeResCache', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$add_role', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'addRole', 'Role', '角色管理', 'swan-cloud-system$role$add_role', '添加角色', '192.168.9.249', '/swan-cloud-system/role/add', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$assign_permission', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'assignPermission', 'Role', '角色管理', 'swan-cloud-system$role$assign_permission', '为角色分配权限', '192.168.9.249', '/swan-cloud-system/role/assign/permission', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$delete_role', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'deleteRole', 'Role', '角色管理', 'swan-cloud-system$role$delete_role', '删除角色', '192.168.9.249', '/swan-cloud-system/role/delete', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$find_all_role', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'findAllRole', 'Role', '角色管理', 'swan-cloud-system$role$find_all_role', '获取所有角色列表', '192.168.9.249', '/swan-cloud-system/role/list', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$find_permissions', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'findPermissions', 'Role', '角色管理', 'swan-cloud-system$role$find_permissions', '查询角色分配的权限', '192.168.9.249', '/swan-cloud-system/role/permissions', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$find_role_all_permissions', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'findRoleAllPermissions', 'Role', '角色管理', 'swan-cloud-system$role$find_role_all_permissions', '查询角色分配的所有权限', '192.168.9.249', '/swan-cloud-system/role/findRoleAllPermissions', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$find_role_detail', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'findRoleDetail', 'Role', '角色管理', 'swan-cloud-system$role$find_role_detail', '获取角色详情', '192.168.9.249', '/swan-cloud-system/role/detail', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$find_role_page', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'findRolePage', 'Role', '角色管理', 'swan-cloud-system$role$find_role_page', '获取角色列表(分页)', '192.168.9.249', '/swan-cloud-system/role/page', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$get_all_res_permissions', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'getAllResPermissions', 'Role', '角色管理', 'swan-cloud-system$role$get_all_res_permissions', '获取用户所有资源列表', '192.168.9.249', '/swan-cloud-system/role/getAllResPermissions', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$get_all_res_permission_urls', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'getAllResPermissionUrls', 'Role', '角色管理', 'swan-cloud-system$role$get_all_res_permission_urls', '获取用户所有资源的url列表', '192.168.9.249', '/swan-cloud-system/role/getAllResPermissionUrls', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$select_role_by_account_id', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'selectRoleByAccountId', 'Role', '角色管理', 'swan-cloud-system$role$select_role_by_account_id', '查询个人角色信息', '192.168.9.249', '/swan-cloud-system/role/selectRoleByAccountId', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$set_status', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'setStatus', 'Role', '角色管理', 'swan-cloud-system$role$set_status', '设置角色状态', '192.168.9.249', '/swan-cloud-system/role/status', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$update_role', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'updateRole', 'Role', '角色管理', 'swan-cloud-system$role$update_role', '更新角色', '192.168.9.249', '/swan-cloud-system/role/update', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$validate_code', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'validateCode', 'Role', '角色管理', 'swan-cloud-system$role$validate_code', '校验角色编码', '192.168.9.249', '/swan-cloud-system/role/validate/code', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$role$validate_name', 'swan-cloud-system', 'swan-cloud-system', 'RoleController', 'validateName', 'Role', '角色管理', 'swan-cloud-system$role$validate_name', '校验角色名称', '192.168.9.249', '/swan-cloud-system/role/validate/name', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$system$get_user_info', 'swan-cloud-system', 'swan-cloud-system', 'SystemController', 'getUserInfo', 'System', '系统信息', 'swan-cloud-system$system$get_user_info', '获取用户基本信息', '192.168.9.249', '/swan-cloud-system/system/getUserInfo', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$system_menu_flag$dic_manager', 'swan-cloud-system', 'swan-cloud-system', 'SystemMenuFlagController', 'dicManager', 'SystemMenuFlag', '系统菜单', 'swan-cloud-system$system_menu_flag$dic_manager', '字典管理', '192.168.9.249', '/swan-cloud-system/systemMenu/dicManager', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$system_menu_flag$system', 'swan-cloud-system', 'swan-cloud-system', 'SystemMenuFlagController', 'system', 'SystemMenuFlag', '系统菜单', 'swan-cloud-system$system_menu_flag$system', '系统管理菜单', '192.168.9.249', '/swan-cloud-system/systemMenu/system', '', 'Y', 'Y', 'Y', -100, '2020-11-25 14:00:03', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$sys_button$add', 'swan-cloud-system', 'swan-cloud-system', 'SysButtonController', 'add', 'SysButton', '按钮接口', 'swan-cloud-system$sys_button$add', '添加', '192.168.9.249', '/swan-cloud-system/sysButton/add', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$sys_button$change_status', 'swan-cloud-system', 'swan-cloud-system', 'SysButtonController', 'changeStatus', 'SysButton', '按钮接口', 'swan-cloud-system$sys_button$change_status', '禁用启用', '192.168.9.249', '/swan-cloud-system/sysButton/changeStatus', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$sys_button$delete', 'swan-cloud-system', 'swan-cloud-system', 'SysButtonController', 'delete', 'SysButton', '按钮接口', 'swan-cloud-system$sys_button$delete', '删除', '192.168.9.249', '/swan-cloud-system/sysButton/delete', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$sys_button$get_button_permission', 'swan-cloud-system', 'swan-cloud-system', 'SysButtonController', 'getButtonPermission', 'SysButton', '按钮接口', 'swan-cloud-system$sys_button$get_button_permission', '获取按钮权限', '192.168.9.249', '/swan-cloud-system/sysButton/buttonPermission', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$sys_button$get_detail', 'swan-cloud-system', 'swan-cloud-system', 'SysButtonController', 'getDetail', 'SysButton', '按钮接口', 'swan-cloud-system$sys_button$get_detail', '获取按钮详情', '192.168.9.249', '/swan-cloud-system/sysButton/getDetail', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$sys_button$get_resources', 'swan-cloud-system', 'swan-cloud-system', 'SysButtonController', 'getResources', 'SysButton', '按钮接口', 'swan-cloud-system$sys_button$get_resources', '获取资源级联列表', '192.168.9.249', '/swan-cloud-system/sysButton/getResources', 'GET', 'N', 'Y', 'N', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$sys_button$query_list_page', 'swan-cloud-system', 'swan-cloud-system', 'SysButtonController', 'queryListPage', 'SysButton', '按钮接口', 'swan-cloud-system$sys_button$query_list_page', '分页查询列表', '192.168.9.249', '/swan-cloud-system/sysButton/queryListPage', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$sys_button$update', 'swan-cloud-system', 'swan-cloud-system', 'SysButtonController', 'update', 'SysButton', '按钮接口', 'swan-cloud-system$sys_button$update', '修改', '192.168.9.249', '/swan-cloud-system/sysButton/update', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:07', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$sys_log$detail', 'swan-cloud-system', 'swan-cloud-system', 'SysLogController', 'detail', 'SysLog', '日志管理', 'swan-cloud-system$sys_log$detail', '登录日志_详情', '192.168.9.249', '/swan-cloud-system/authLoginLog/detail', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:06', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$sys_log$login_log_page', 'swan-cloud-system', 'swan-cloud-system', 'SysLogController', 'loginLogPage', 'SysLog', '日志管理', 'swan-cloud-system$sys_log$login_log_page', '登录日志_查询', '192.168.9.249', '/swan-cloud-system/authLoginLog/pageList', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:06', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$sys_log$op_log_delete', 'swan-cloud-system', 'swan-cloud-system', 'SysLogController', 'opLogDelete', 'SysLog', '日志管理', 'swan-cloud-system$sys_log$op_log_delete', '操作日志_清空', '192.168.9.249', '/swan-cloud-system/sysOpLog/delete', 'POST', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:06', NULL, NULL);
INSERT INTO `swan_sys_resource` (`resource_id`, `app_code`, `project_code`, `class_name`, `method_name`, `modular_code`, `modular_name`, `code`, `name`, `ip_address`, `url`, `http_method`, `menu_flag`, `required_login_flag`, `required_permission_flag`, `create_user`, `create_time`, `update_user`, `update_time`) VALUES ('swan-cloud-system$sys_log$op_log_page', 'swan-cloud-system', 'swan-cloud-system', 'SysLogController', 'opLogPage', 'SysLog', '日志管理', 'swan-cloud-system$sys_log$op_log_page', '操作日志_查询', '192.168.9.249', '/swan-cloud-system/sysOpLog/page', 'GET', 'N', 'Y', 'Y', -100, '2020-11-25 14:00:06', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for swan_sys_role
-- ----------------------------
DROP TABLE IF EXISTS `swan_sys_role`;
CREATE TABLE `swan_sys_role`  (
  `role_id` bigint(20) NOT NULL COMMENT '角色id',
  `role_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色编码',
  `role_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `role_desc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色描述',
  `order_no` decimal(11, 2) NULL DEFAULT NULL COMMENT '排序码',
  `status` int(11) NULL DEFAULT NULL COMMENT '状态(1:启用  2:禁用)',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '删除标记(Y:已删除 N:未删除)',
  PRIMARY KEY (`role_id`) USING BTREE,
  UNIQUE INDEX `CODE_UNI`(`role_code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表';

-- ----------------------------
-- Records of swan_sys_role
-- ----------------------------
BEGIN;
INSERT INTO `swan_sys_role` (`role_id`, `role_code`, `role_name`, `role_desc`, `order_no`, `status`, `create_time`, `create_user`, `update_time`, `update_user`, `del_flag`) VALUES (1184285447301570561, 'system_role', '系统管理员角色', '这是系统管理员角色。', 1.00, 1, '2019-10-16 01:50:28', -100, '2020-10-28 17:24:22', 1184285445204418561, 'N');
INSERT INTO `swan_sys_role` (`role_id`, `role_code`, `role_name`, `role_desc`, `order_no`, `status`, `create_time`, `create_user`, `update_time`, `update_user`, `del_flag`) VALUES (1321041340402376706, '5555', '普通管理员', '这是普通管理员', 5.00, 1, '2020-10-27 18:49:34', 1184285445204418561, '2020-10-29 10:53:13', 1184285445204418561, 'N');
COMMIT;

-- ----------------------------
-- Table structure for swan_sys_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `swan_sys_role_permission`;
CREATE TABLE `swan_sys_role_permission`  (
  `role_permission_id` bigint(20) NOT NULL COMMENT '角色权限id',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `permission_id` bigint(20) NOT NULL COMMENT '权限ID',
  PRIMARY KEY (`role_permission_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色权限表';

-- ----------------------------
-- Records of swan_sys_role_permission
-- ----------------------------
BEGIN;
INSERT INTO `swan_sys_role_permission` (`role_permission_id`, `role_id`, `permission_id`) VALUES (1322055958409207810, 1184285447301570561, 1184285448379506690);
INSERT INTO `swan_sys_role_permission` (`role_permission_id`, `role_id`, `permission_id`) VALUES (1322055958409207811, 1184285447301570561, 1322051793364672513);
INSERT INTO `swan_sys_role_permission` (`role_permission_id`, `role_id`, `permission_id`) VALUES (1328510553760296961, 1321041340402376706, 1322051793364672513);
COMMIT;

-- ----------------------------
-- Table structure for swan_sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `swan_sys_user_role`;
CREATE TABLE `swan_sys_user_role`  (
  `user_role_id` bigint(20) NOT NULL COMMENT '用户角色id',
  `account_id` bigint(20) NOT NULL COMMENT '账户id',
  `role_id` bigint(20) NOT NULL COMMENT '角色id',
  PRIMARY KEY (`user_role_id`) USING BTREE,
  INDEX `role_id`(`role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色表';

-- ----------------------------
-- Records of swan_sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `swan_sys_user_role` (`user_role_id`, `account_id`, `role_id`) VALUES (1184285447838441474, 1184285445204418561, 1184285447301570561);
INSERT INTO `swan_sys_user_role` (`user_role_id`, `account_id`, `role_id`) VALUES (1321374285650685954, 1321368217809809410, 1321041340402376706);
INSERT INTO `swan_sys_user_role` (`user_role_id`, `account_id`, `role_id`) VALUES (1321995192758919169, 1192435299083378690, 1321041340402376706);
INSERT INTO `swan_sys_user_role` (`user_role_id`, `account_id`, `role_id`) VALUES (1322068212659740674, 1192434377959694338, 1321041340402376706);
INSERT INTO `swan_sys_user_role` (`user_role_id`, `account_id`, `role_id`) VALUES (1322068670686126081, 1192434377959694338, 1321041340402376706);
INSERT INTO `swan_sys_user_role` (`user_role_id`, `account_id`, `role_id`) VALUES (1322068670690320385, 1192434377959694338, 1184285447301570561);
INSERT INTO `swan_sys_user_role` (`user_role_id`, `account_id`, `role_id`) VALUES (1322068688943931393, 1192434377959694338, 1321041340402376706);
INSERT INTO `swan_sys_user_role` (`user_role_id`, `account_id`, `role_id`) VALUES (1323172487087505409, 1192435904476635137, 1321041340402376706);
INSERT INTO `swan_sys_user_role` (`user_role_id`, `account_id`, `role_id`) VALUES (1323443767577657346, 1321998412927426561, 1321041340402376706);
INSERT INTO `swan_sys_user_role` (`user_role_id`, `account_id`, `role_id`) VALUES (1328510609649397762, 1321991053345775618, 1321041340402376706);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
